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 774: from wip_entities

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
774: from wip_entities
775: where wip_entity_id = to_number(txn_source_id);
776: return(txn_source);
777: elsif Type_id = 7 then select segment1 into txn_source
778: from po_requisition_headers_all

Line 853: from wip_entities

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
853: from wip_entities
854: where wip_entity_id = to_number(txn_source_id);
855: return(txn_source);
856: elsif Type_id1 = 7 then select segment1 into txn_source
857: from po_requisition_headers_all

Line 932: from wip_entities

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
932: from wip_entities
933: where wip_entity_id = to_number(txn_source_id);
934: return(txn_source);
935: elsif Type_id2 = 7 then select segment1 into txn_source
936: from po_requisition_headers_all

Line 1011: from wip_entities

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
1011: from wip_entities
1012: where wip_entity_id = to_number(txn_source_id);
1013: return(txn_source);
1014: elsif Type_id3 = 7 then select segment1 into txn_source
1015: from po_requisition_headers_all

Line 1090: from wip_entities

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
1090: from wip_entities
1091: where wip_entity_id = to_number(txn_source_id);
1092: return(txn_source);
1093: elsif Type_id4 = 7 then select segment1 into txn_source
1094: from po_requisition_headers_all