You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Requisitioning BU have null value for header and header lines

Accepted answer
31
Views
1
Comments

I made the following query to give me the open agreements and their lines,

in the table, some lines had a Requisitioning BU value but the majority does not.

In this query, none of the rows have a value for the req_bu_id

Am I using the wrong tables, or am I should modify the conditions of the query ?


The query:

select pha.po_header_id agreement_id, 

pha.req_bu_id agreement_req_bu_id, 

pha.segment1 contract,  

pos.party_name supplier,

pha.currency_code,   

pla.po_line_id agreement_item_id,  

pla.item_id inventory_item_id, 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!