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 874: from mtl_physical_inventories

870: and organization_id = org_id;
871: return(txn_source);
872: elsif Type_id = 10 then
873: select physical_inventory_name into txn_source
874: from mtl_physical_inventories
875: where physical_inventory_id = to_number(txn_source_id)
876: and organization_id = org_id;
877: return(txn_source);
878: elsif Type_id = 11 then

Line 953: from mtl_physical_inventories

949: and organization_id = org_id;
950: return(txn_source);
951: elsif Type_id1 = 10 then
952: select physical_inventory_name into txn_source
953: from mtl_physical_inventories
954: where physical_inventory_id = to_number(txn_source_id)
955: and organization_id = org_id;
956: return(txn_source);
957: elsif Type_id1 = 11 then

Line 1032: from mtl_physical_inventories

1028: and organization_id = org_id;
1029: return(txn_source);
1030: elsif Type_id2 = 10 then
1031: select physical_inventory_name into txn_source
1032: from mtl_physical_inventories
1033: where physical_inventory_id = to_number(txn_source_id)
1034: and organization_id = org_id;
1035: return(txn_source);
1036: elsif Type_id2 = 11 then

Line 1111: from mtl_physical_inventories

1107: and organization_id = org_id;
1108: return(txn_source);
1109: elsif Type_id3 = 10 then
1110: select physical_inventory_name into txn_source
1111: from mtl_physical_inventories
1112: where physical_inventory_id = to_number(txn_source_id)
1113: and organization_id = org_id;
1114: return(txn_source);
1115: elsif Type_id3 = 11 then

Line 1190: from mtl_physical_inventories

1186: and organization_id = org_id;
1187: return(txn_source);
1188: elsif Type_id4 = 10 then
1189: select physical_inventory_name into txn_source
1190: from mtl_physical_inventories
1191: where physical_inventory_id = to_number(txn_source_id)
1192: and organization_id = org_id;
1193: return(txn_source);
1194: elsif Type_id4 = 11 then