DBA Data[Home] [Help]

APPS.JAI_AP_RPT_APCR_PKG dependencies on RCV_TRANSACTIONS

Line 999: from rcv_transactions

995: select receipt_num, trunc(creation_date) receipt_date
996: from rcv_shipment_headers
997: where shipment_header_id =
998: ( select shipment_header_id
999: from rcv_transactions
1000: where transaction_id = p_transaction_id);
1001:
1002:
1003: cursor c_get_tax_from_ap (

Line 1052: from rcv_transactions

1048: from JAI_RCV_LINE_TAXES
1049: where (shipment_header_id, shipment_line_id)
1050: in
1051: (select shipment_header_id, shipment_line_id
1052: from rcv_transactions
1053: where transaction_id = p_rcv_transaction_id)
1054: and tax_id not in
1055: (
1056: select tax_id