DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on MTL_SYSTEM_ITEMS_VL

Line 2033: , mtl_system_items_vl sitems

2029: SELECT DECODE(items.org_independent_flag, 'Y', 1,
2030: DECODE(items.organization_id, item_val_org, 1, 2))
2031: FROM mtl_cross_reference_types types
2032: , mtl_cross_references items
2033: , mtl_system_items_vl sitems
2034: WHERE types.cross_reference_type = items.cross_reference_type
2035: AND items.inventory_item_id = sitems.inventory_item_id
2036: AND sitems.organization_id = item_val_org
2037: AND sitems.inventory_item_id = p_inventory_item_id

Line 2076: ,mtl_system_items_vl sitems

2072: SELECT 'valid'
2073: INTO l_dummy
2074: FROM mtl_customer_items citems
2075: ,mtl_customer_item_xrefs cxref
2076: ,mtl_system_items_vl sitems
2077: WHERE citems.customer_item_id = cxref.customer_item_id
2078: AND cxref.inventory_item_id = sitems.inventory_item_id
2079: AND sitems.inventory_item_id = p_inventory_item_id
2080: AND sitems.organization_id =