DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_CC_SUBINVENTORIES

Line 2472: FROM mtl_secondary_inventories msub, mtl_cc_subinventories mccs

2468: , msub.description
2469: , msub.asset_inventory
2470: , msub.lpn_controlled_flag
2471: , msub.enable_locator_alias
2472: FROM mtl_secondary_inventories msub, mtl_cc_subinventories mccs
2473: WHERE msub.organization_id = p_organization_id
2474: AND mccs.cycle_count_header_id = p_cycle_count_header_id
2475: AND mccs.subinventory = msub.secondary_inventory_name
2476: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)