APPS.MSC_X_VMI_POREQ dependencies on MTL_SYSTEM_ITEMS

Line 315: -- Populating SECONDARY_UOM_CODE and SECONDARY_QUANTITY in PO_REQUISITIONS_INTERFACE_ALL from MTL_SYSTEM_ITEMS

311:
312: End loop;
313:
314: -- fix for 2541517
315: -- Populating SECONDARY_UOM_CODE and SECONDARY_QUANTITY in PO_REQUISITIONS_INTERFACE_ALL from MTL_SYSTEM_ITEMS
316: BEGIN
317:
318:
319: SELECT pri.rowid,

Line 327: MTL_SYSTEM_ITEMS msi

323: INTO lv_pri_rowid,
324: lv_sec_uom_code,
325: lv_sec_uom_qty
326: FROM PO_REQUISITIONS_INTERFACE_ALL pri,
327: MTL_SYSTEM_ITEMS msi
328: WHERE pri.ITEM_ID = msi.INVENTORY_ITEM_ID
329: AND pri.DESTINATION_ORGANIZATION_ID = msi.ORGANIZATION_ID
330: AND msi.SECONDARY_UOM_CODE is not NULL
331: AND pri.batch_id = l_PO_BATCH_NUMBER;

Line 358: FROM mtl_system_items_b msi,

354: BEGIN
355: SELECT max(rev.revision),
356: max(msi.revision_qty_control_code)
357: INTO var_revision,var_revision_ctrl
358: FROM mtl_system_items_b msi,
359: mtl_item_revisions rev
360: WHERE msi.inventory_item_id = ctemp.item_id
361: AND msi.organization_id = ctemp.destination_organization_id
362: AND rev.inventory_item_id = msi.inventory_item_id

Line 714: OE_BLANKET_HEADERS_EXT BHE,MTL_SYSTEM_ITEMS_TL T,OE_LOOKUPS OL

710: FROM
711: (
712: SELECT BH.ORDER_NUMBER order_number, bh.TRANSACTIONAL_CURR_CODE curr, bh.FLOW_STATUS_CODE status
713: FROM OE_BLANKET_LINES BL,OE_BLANKET_HEADERS BH,OE_BLANKET_LINES_EXT BLE,
714: OE_BLANKET_HEADERS_EXT BHE,MTL_SYSTEM_ITEMS_TL T,OE_LOOKUPS OL
715: ,HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS ACCT
716: WHERE BH.HEADER_ID = BL.HEADER_ID
717: AND BL.LINE_ID = BLE.LINE_ID
718: AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER