DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PUB dependencies on PO_HEADERS_ALL

Line 5002: from po_headers_all poh, po_lines_all pol

4998: print_debug('Inside p_global_procurement_flag =Y', 'GET_TRANSFER_PRICE_DATE');
4999: begin
5000: select poh.approved_date
5001: into l_trf_price_date
5002: from po_headers_all poh, po_lines_all pol
5003: where poh.po_header_id = pol.po_header_id
5004: and pol.po_line_id = p_order_line_id;
5005: exception
5006: when no_data_found then

Line 5095: FROM rcv_transactions rcv, po_headers_all poh

5091: print_debug('Inside p_global_procurement_flag =Y', 'GET_TRANSFER_PRICE_DATE');
5092: begin
5093: SELECT poh.approved_date
5094: into l_trf_price_date
5095: FROM rcv_transactions rcv, po_headers_all poh
5096: WHERE rcv.transaction_id = p_transaction_id
5097: AND rcv.po_header_id = poh.po_header_id;
5098: exception
5099: when no_data_found then