DBA Data[Home] [Help]

APPS.MRP_AP_REL_PLAN_PUB dependencies on MTL_SYSTEM_ITEMS

Line 2637: from mtl_system_items msi,

2633: (Select nvl(mapv.material_account,
2634: decode( msi.inventory_asset_flag,
2635: 'Y', mp.material_account,
2636: nvl(msi.expense_account, mp.expense_account)))
2637: from mtl_system_items msi,
2638: mtl_parameters mp,
2639: /* Bug 3341083 Note: Any changes to from clause or where clause of MRP_AP_PROJECTS_V, needs a corresponding change to this inline view*/
2640: (SELECT ppp.Project_ID,
2641: ppp.Organization_ID,

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

2690:
2691: End loop;
2692:
2693: -- fix for 2541517
2694: -- Populating SECONDARY_UOM_CODE and SECONDARY_QUANTITY in PO_REQUISITIONS_INTERFACE_ALL from MTL_SYSTEM_ITEMS
2695: BEGIN
2696: SELECT pri.rowid,
2697: msi.SECONDARY_UOM_CODE,
2698: inv_convert.inv_um_convert(pri.ITEM_ID,9,pri.QUANTITY,pri.UOM_CODE,msi.SECONDARY_UOM_CODE,null,null)

Line 2704: MTL_SYSTEM_ITEMS msi

2700: INTO lv_pri_rowid,
2701: lv_sec_uom_code,
2702: lv_sec_uom_qty
2703: FROM PO_REQUISITIONS_INTERFACE_ALL pri,
2704: MTL_SYSTEM_ITEMS msi
2705: WHERE pri.ITEM_ID = msi.INVENTORY_ITEM_ID
2706: AND pri.DESTINATION_ORGANIZATION_ID = msi.ORGANIZATION_ID
2707: AND msi.SECONDARY_UOM_CODE is not NULL
2708: AND pri.batch_id = G_PO_BATCH_NUMBER;

Line 2734: FROM mtl_system_items_b msi,

2730: BEGIN
2731: SELECT max(rev.revision),
2732: max(msi.revision_qty_control_code)
2733: INTO var_revision,var_revision_ctrl
2734: FROM mtl_system_items_b msi,
2735: mtl_item_revisions rev
2736: WHERE msi.inventory_item_id = ctemp.item_id
2737: AND msi.organization_id = ctemp.destination_organization_id
2738: AND rev.inventory_item_id = msi.inventory_item_id