APPS.INV_INVTRDST_XMLP_PKG dependencies on WIP_ENTITIES

Line 505: RETURN ('wip_entities wipe,');

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;
507: IF P_SOURCE_TYPE_ID = 7 AND (P_SOURCE_HI IS NOT NULL OR P_SOURCE_LO IS NOT NULL) THEN
508: RETURN ('po_requisition_headers prh,');
509: END IF;

Line 858: from wip_entities

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
858: from wip_entities
859: where wip_entity_id = to_number(txn_source_id);
860: return(txn_source);
861: elsif Type_id = 7 then select segment1 into txn_source
862: from po_requisition_headers_all

Line 937: from wip_entities

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
937: from wip_entities
938: where wip_entity_id = to_number(txn_source_id);
939: return(txn_source);
940: elsif Type_id1 = 7 then select segment1 into txn_source
941: from po_requisition_headers_all

Line 1016: from wip_entities

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
1016: from wip_entities
1017: where wip_entity_id = to_number(txn_source_id);
1018: return(txn_source);
1019: elsif Type_id2 = 7 then select segment1 into txn_source
1020: from po_requisition_headers_all

Line 1095: from wip_entities

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
1095: from wip_entities
1096: where wip_entity_id = to_number(txn_source_id);
1097: return(txn_source);
1098: elsif Type_id3 = 7 then select segment1 into txn_source
1099: from po_requisition_headers_all

Line 1174: from wip_entities

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
1174: from wip_entities
1175: where wip_entity_id = to_number(txn_source_id);
1176: return(txn_source);
1177: elsif Type_id4 = 7 then select segment1 into txn_source
1178: from po_requisition_headers_all