APPS.JAI_RCV_TAX_PKG dependencies on JAI_RCV_TRANSACTIONS

Line 301: from JAI_RCV_TRANSACTIONS

297: cursor c_fetch_transaction_quantity(p_shipment_header_id number,
298: p_shipment_line_id number ,
299: p_transaction_type varchar2) is
300: select sum(quantity)
301: from JAI_RCV_TRANSACTIONS
302: where shipment_header_id = p_shipment_header_id
303: and shipment_line_id = p_shipment_line_id
304: and transaction_type = p_transaction_type;
305:

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

1156: through a DFF : invoice no, invoice_date, Claim Cenvat On Receipt etc.
1157: This DFF is provided at two places, header and line.
1158: Information from the header DFF is captured into the rcv_shipment_headers table.
1159: Information from the lines DFF is captured into the rcv_transactions table.
1160: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.
1161: At this time, a facility has been provided for the user to default the information
1162: given at the header level DFF to all the lines only if these columns are null at the
1163: line level. Else the information in the line level DFF is sustained.
1164: For this NVL conditions have been added where this information gets defaulted.