APPS.INV_TRANSACTION_FLOW_PUB dependencies on IC_TRAN_PND

Line 3255: FROM ic_tran_pnd

3251: IF ( GML_PROCESS_FLAGS.process_orgn = 1 AND GML_PROCESS_FLAGS.opmitem_flag = 1 ) THEN
3252:
3253: SELECT doc_type, line_id, whse_code
3254: INTO l_doc_type, l_line_id, l_whse_code
3255: FROM ic_tran_pnd
3256: WHERE trans_id = p_reference_id;
3257:
3258: IF l_doc_type = 'OMSO' THEN
3259: SELECT WHS.mtl_organization_id, oeh.ordered_date

Line 5018: from ic_tran_pnd

5014: --OPM Flow
5015: print_debug('Inside OPM Flow', 'GET_TRANSFER_PRICE_DATE');
5016: select doc_type, line_id, whse_code
5017: into l_doc_type, l_line_id, l_whse_code
5018: from ic_tran_pnd
5019: where trans_id = p_transaction_id;
5020: if l_doc_type = 'OMSO' then
5021: begin
5022: select oel.pricing_date