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 769: from mtl_txn_request_headers

765: where po_header_id = to_number(txn_source_id);
766: return(txn_source);
767: elsif Type_id = 4 then --for Bug#3919355
768: select request_number into txn_source
769: from mtl_txn_request_headers
770: where header_id = to_number(txn_source_id);
771: return(txn_source);
772: elsif Type_id = 5 then
773: select wip_entity_name into txn_source

Line 848: from mtl_txn_request_headers

844: where po_header_id = to_number(txn_source_id);
845: return(txn_source);
846: elsif Type_id1 = 4 then --For Bug#3919355
847: select request_number into txn_source
848: from mtl_txn_request_headers
849: where header_id = to_number(txn_source_id);
850: return(txn_source);
851: elsif Type_id1 = 5 then
852: select wip_entity_name into txn_source

Line 927: from mtl_txn_request_headers

923: where po_header_id = to_number(txn_source_id);
924: return(txn_source);
925: elsif Type_id2 = 4 then --For Bug#3919355
926: select request_number into txn_source
927: from mtl_txn_request_headers
928: where header_id = to_number(txn_source_id);
929: return(txn_source);
930: elsif Type_id2 = 5 then
931: select wip_entity_name into txn_source

Line 1006: from mtl_txn_request_headers

1002: where po_header_id = to_number(txn_source_id);
1003: return(txn_source);
1004: elsif Type_id3 = 4 then --For Bug#3919355
1005: select request_number into txn_source
1006: from mtl_txn_request_headers
1007: where header_id = to_number(txn_source_id);
1008: return(txn_source);
1009: elsif Type_id3 = 5 then
1010: select wip_entity_name into txn_source

Line 1085: from mtl_txn_request_headers

1081: where po_header_id = to_number(txn_source_id);
1082: return(txn_source);
1083: elsif Type_id4 = 4 then --For Bug#3919355
1084: select request_number into txn_source
1085: from mtl_txn_request_headers
1086: where header_id = to_number(txn_source_id);
1087: return(txn_source);
1088: elsif Type_id4 = 5 then
1089: select wip_entity_name into txn_source