APPS.INV_INVTRDST_XMLP_PKG dependencies on MTL_PHYSICAL_INVENTORIES

Line 514: RETURN ('mtl_physical_inventories pi,');

510: IF P_SOURCE_TYPE_ID = 9 AND (P_SOURCE_HI IS NOT NULL OR P_SOURCE_LO IS NOT NULL) THEN
511: RETURN ('mtl_cycle_count_headers cch,');
512: END IF;
513: IF P_SOURCE_TYPE_ID = 10 AND (P_SOURCE_HI IS NOT NULL OR P_SOURCE_LO IS NOT NULL) THEN
514: RETURN ('mtl_physical_inventories pi,');
515: END IF;
516: IF P_SOURCE_TYPE_ID = 11 AND (P_SOURCE_HI IS NOT NULL OR P_SOURCE_LO IS NOT NULL) THEN
517: RETURN ('cst_cost_updates cst,');
518: END IF;

Line 790: from mtl_physical_inventories

786: and organization_id = org_id;
787: return(txn_source);
788: elsif Type_id = 10 then
789: select physical_inventory_name into txn_source
790: from mtl_physical_inventories
791: where physical_inventory_id = to_number(txn_source_id)
792: and organization_id = org_id;
793: return(txn_source);
794: elsif Type_id = 11 then

Line 869: from mtl_physical_inventories

865: and organization_id = org_id;
866: return(txn_source);
867: elsif Type_id1 = 10 then
868: select physical_inventory_name into txn_source
869: from mtl_physical_inventories
870: where physical_inventory_id = to_number(txn_source_id)
871: and organization_id = org_id;
872: return(txn_source);
873: elsif Type_id1 = 11 then

Line 948: from mtl_physical_inventories

944: and organization_id = org_id;
945: return(txn_source);
946: elsif Type_id2 = 10 then
947: select physical_inventory_name into txn_source
948: from mtl_physical_inventories
949: where physical_inventory_id = to_number(txn_source_id)
950: and organization_id = org_id;
951: return(txn_source);
952: elsif Type_id2 = 11 then

Line 1027: from mtl_physical_inventories

1023: and organization_id = org_id;
1024: return(txn_source);
1025: elsif Type_id3 = 10 then
1026: select physical_inventory_name into txn_source
1027: from mtl_physical_inventories
1028: where physical_inventory_id = to_number(txn_source_id)
1029: and organization_id = org_id;
1030: return(txn_source);
1031: elsif Type_id3 = 11 then

Line 1106: from mtl_physical_inventories

1102: and organization_id = org_id;
1103: return(txn_source);
1104: elsif Type_id4 = 10 then
1105: select physical_inventory_name into txn_source
1106: from mtl_physical_inventories
1107: where physical_inventory_id = to_number(txn_source_id)
1108: and organization_id = org_id;
1109: return(txn_source);
1110: elsif Type_id4 = 11 then