DBA Data[Home] [Help]

APPS.JAI_AP_RPT_APCR_PKG dependencies on RCV_TRANSACTIONS

Line 1041: from rcv_transactions

1037: select receipt_num, trunc(creation_date) receipt_date
1038: from rcv_shipment_headers
1039: where shipment_header_id =
1040: ( select shipment_header_id
1041: from rcv_transactions
1042: where transaction_id = p_transaction_id);
1043:
1044:
1045: cursor c_get_tax_from_ap (

Line 1094: from rcv_transactions

1090: from JAI_RCV_LINE_TAXES
1091: where (shipment_header_id, shipment_line_id)
1092: in
1093: (select shipment_header_id, shipment_line_id
1094: from rcv_transactions
1095: where transaction_id = p_rcv_transaction_id)
1096: and tax_id not in
1097: (
1098: select tax_id