DBA Data[Home] [Help]

APPS.WIP_FLOW_DERIVE dependencies on MTL_SECONDARY_INVENTORIES

Line 842: from mtl_secondary_inventories

838: if p_comp_sub is not null then
839: BEGIN
840: select null,null /*completion subinventory is inactive */
841: into p_comp_sub,p_comp_loc
842: from mtl_secondary_inventories
843: where organization_id = p_org_id
844: and secondary_inventory_name = p_comp_sub
845: and (
846: NVL(disable_date, TRUNC(p_start_date)+1) <= TRUNC(p_start_date)