APPS.JAI_RCV_TAX_PKG dependencies on JAI_RCV_TRANSACTIONS

Line 323: from JAI_RCV_TRANSACTIONS

319: cursor c_fetch_transaction_quantity(p_shipment_header_id number,
320: p_shipment_line_id number ,
321: p_transaction_type varchar2) is
322: select sum(quantity)
323: from JAI_RCV_TRANSACTIONS
324: where shipment_header_id = p_shipment_header_id
325: and shipment_line_id = p_shipment_line_id
326: and transaction_type = p_transaction_type;
327:

Line 1252: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.

1248: through a DFF : invoice no, invoice_date, Claim Cenvat On Receipt etc.
1249: This DFF is provided at two places, header and line.
1250: Information from the header DFF is captured into the rcv_shipment_headers table.
1251: Information from the lines DFF is captured into the rcv_transactions table.
1252: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.
1253: At this time, a facility has been provided for the user to default the information
1254: given at the header level DFF to all the lines only if these columns are null at the
1255: line level. Else the information in the line level DFF is sustained.
1256: For this NVL conditions have been added where this information gets defaulted.