DBA Data[Home] [Help]

APPS.ICX_CAT_FPI_UPGRADE dependencies on MTL_SYSTEM_ITEMS

Line 788: mtl_system_items msi

784: TO_NUMBER(NULL) buyer_id,
785: sub.rowid row_id
786: FROM icx_por_oracle_item_subtable sub,
787: icx_por_items item,
788: mtl_system_items msi
789: WHERE sub.rt_item_id = p_rt_item_id
790: AND sub.orc_template_id is null
791: AND sub.orc_contract_id is null
792: AND sub.orc_asl_id is null

Line 1802: mtl_system_items_kfv mi,

1798: gUpgradeUserId, gUpgradeUserId, sysdate,
1799: gUpgradeUserId, sysdate, gUpgradeUserId,
1800: gUpgradeUserId, gUpgradeUserId, sysdate
1801: FROM icx_cat_item_prices p,
1802: mtl_system_items_kfv mi,
1803: gl_sets_of_books gsb,
1804: financials_system_params_all fsp,
1805: mtl_units_of_measure_tl muom
1806: WHERE p.inventory_item_id = mi.inventory_item_id

Line 1952: FROM mtl_system_items_kfv mi,

1948: NULL, NULL, NULL, NULL,
1949: gUpgradeUserId, gUpgradeUserId, sysdate,
1950: gUpgradeUserId, sysdate, gUpgradePhaseId,
1951: gUpgradeUserId, gUpgradeUserId, sysdate
1952: FROM mtl_system_items_kfv mi,
1953: mtl_item_categories mic,
1954: gl_sets_of_books gsb,
1955: financials_system_params_all fsp,
1956: --Bug#3581356