APPS.PO_PDOI_DIST_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 4100: FROM mtl_system_items

4096: SELECT p_key,
4097: p_index_tbl(i),
4098: DECODE(outside_operation_flag,'Y','O',
4099: DECODE(stock_enabled_flag,'Y','E','D'))
4100: FROM mtl_system_items
4101: WHERE organization_id = p_ship_to_org_id_tbl(i)
4102: AND inventory_item_id = p_item_id_tbl(i);
4103:
4104: d_position := 10;

Line 4268: -- inventories, then mtl_system_items and finally mtl_parameters

4264:
4265: d_position := 70;
4266:
4267: -- first try to get it from mtl_item_sub_inventories, then mtl_secondary_
4268: -- inventories, then mtl_system_items and finally mtl_parameters
4269: -- Bug6811980 (including the exception block)
4270: BEGIN
4271: SELECT NVL(misi.encumbrance_account, msci.encumbrance_account)
4272: INTO x_budget_account_id

Line 4293: FROM mtl_system_items msi,

4289: d_position := 80;
4290:
4291: SELECT NVL(msi.encumbrance_account, mp.encumbrance_account)
4292: INTO x_budget_account_id
4293: FROM mtl_system_items msi,
4294: mtl_parameters mp
4295: WHERE p_item_id = msi.inventory_item_id
4296: AND p_dest_org_id = msi.organization_id
4297: AND mp.organization_id = p_dest_org_id;