DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_CC_SUBINVENTORIES

Line 2095: FROM mtl_secondary_inventories msub, mtl_cc_subinventories mccs

2091: , msub.description
2092: , msub.asset_inventory
2093: , msub.lpn_controlled_flag
2094: , msub.enable_locator_alias
2095: FROM mtl_secondary_inventories msub, mtl_cc_subinventories mccs
2096: WHERE msub.organization_id = p_organization_id
2097: AND mccs.cycle_count_header_id = p_cycle_count_header_id
2098: AND mccs.subinventory = msub.secondary_inventory_name
2099: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)