APPS.INV_INVTRDST_XMLP_PKG dependencies on MTL_TXN_REQUEST_HEADERS

Line 502: RETURN ('mtl_txn_request_headers mtrh,');

498: IF P_SOURCE_TYPE_ID = 1 AND (P_SOURCE_HI IS NOT NULL OR P_SOURCE_LO IS NOT NULL) THEN
499: RETURN ('po_headers poh,');
500: END IF;
501: IF P_SOURCE_TYPE_ID = 4 AND (P_SOURCE_HI IS NOT NULL OR P_SOURCE_LO IS NOT NULL) THEN
502: RETURN ('mtl_txn_request_headers mtrh,');
503: END IF;
504: IF P_SOURCE_TYPE_ID = 5 AND (P_SOURCE_HI IS NOT NULL OR P_SOURCE_LO IS NOT NULL) THEN
505: RETURN ('wip_entities wipe,');
506: END IF;

Line 853: from mtl_txn_request_headers

849: where po_header_id = to_number(txn_source_id);
850: return(txn_source);
851: elsif Type_id = 4 then --for Bug#3919355
852: select request_number into txn_source
853: from mtl_txn_request_headers
854: where header_id = to_number(txn_source_id);
855: return(txn_source);
856: elsif Type_id = 5 then
857: select wip_entity_name into txn_source

Line 932: from mtl_txn_request_headers

928: where po_header_id = to_number(txn_source_id);
929: return(txn_source);
930: elsif Type_id1 = 4 then --For Bug#3919355
931: select request_number into txn_source
932: from mtl_txn_request_headers
933: where header_id = to_number(txn_source_id);
934: return(txn_source);
935: elsif Type_id1 = 5 then
936: select wip_entity_name into txn_source

Line 1011: from mtl_txn_request_headers

1007: where po_header_id = to_number(txn_source_id);
1008: return(txn_source);
1009: elsif Type_id2 = 4 then --For Bug#3919355
1010: select request_number into txn_source
1011: from mtl_txn_request_headers
1012: where header_id = to_number(txn_source_id);
1013: return(txn_source);
1014: elsif Type_id2 = 5 then
1015: select wip_entity_name into txn_source

Line 1090: from mtl_txn_request_headers

1086: where po_header_id = to_number(txn_source_id);
1087: return(txn_source);
1088: elsif Type_id3 = 4 then --For Bug#3919355
1089: select request_number into txn_source
1090: from mtl_txn_request_headers
1091: where header_id = to_number(txn_source_id);
1092: return(txn_source);
1093: elsif Type_id3 = 5 then
1094: select wip_entity_name into txn_source

Line 1169: from mtl_txn_request_headers

1165: where po_header_id = to_number(txn_source_id);
1166: return(txn_source);
1167: elsif Type_id4 = 4 then --For Bug#3919355
1168: select request_number into txn_source
1169: from mtl_txn_request_headers
1170: where header_id = to_number(txn_source_id);
1171: return(txn_source);
1172: elsif Type_id4 = 5 then
1173: select wip_entity_name into txn_source