DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on MTL_SYSTEM_ITEMS_VL

Line 818: l_Item_rec MTL_SYSTEM_ITEMS_VL%ROWTYPE;

814: 62, 65, 70, 80, 90, 100, 120, 130));
815:
816: l_Attribute_Code mtl_item_attributes.attribute_name%TYPE;
817: m_Item_rec MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
818: l_Item_rec MTL_SYSTEM_ITEMS_VL%ROWTYPE;
819: l_create_child BOOLEAN := FALSE;
820:
821: BEGIN
822:

Line 829: FROM mtl_system_items_vl

825: FROM mtl_system_items_interface
826: WHERE rowid = mast_rowid;
827:
828: SELECT * INTO l_Item_rec
829: FROM mtl_system_items_vl
830: WHERE inventory_item_id = item_id
831: AND organization_id = org_id;
832:
833: OPEN c_master_attributes;

Line 2364: MTL_SYSTEM_ITEMS_VL MSI

2360: MSI.TRADE_ITEM_DESCRIPTOR,
2361: MSI.STYLE_ITEM_FLAG,
2362: MSI.STYLE_ITEM_ID
2363: FROM
2364: MTL_SYSTEM_ITEMS_VL MSI
2365: WHERE
2366: MSI.inventory_item_id = inv_item_id
2367: AND MSI.organization_id = org_id;
2368: