DBA Data[Home] [Help]

APPS.WSH_WV_PVT dependencies on MTL_PARAMETERS

Line 714: FROM mtl_parameters

710: AND pc.container_inventory_item_id = cl.load_item_id
711: AND cl.container_item_id = x_veh_id
712: AND cl.master_organization_id =
713: (SELECT master_organization_id
714: FROM mtl_parameters
715: WHERE organization_id = x_o_id)
716: AND NVL(cl.max_load_quantity, 0) > 0
717: AND (pc.parent_sequence_number IS NULL
718: OR not exists (select sequence_number from wsh_packed_containers

Line 1984: FROM mtl_parameters

1980: AND item_msi.organization_id = x_o_id
1981: AND wcl.load_item_id = dl.inventory_item_id
1982: AND wcl.master_organization_id =
1983: (SELECT master_organization_id
1984: FROM mtl_parameters
1985: WHERE organization_id = x_o_id)
1986: AND wcl.container_item_id = NVL(dl.master_container_item_id,
1987: dl.detail_container_item_id)
1988: AND wcl.max_load_quantity > 0

Line 2017: FROM mtl_parameters

2013: AND item_msi.organization_id = x_o_id
2014: AND wcl.load_item_id = item_msi.inventory_item_id
2015: AND wcl.master_organization_id =
2016: (SELECT master_organization_id
2017: FROM mtl_parameters
2018: WHERE organization_id = x_o_id)
2019: AND wcl.container_item_id = NVL(dl.master_container_item_id,
2020: dl.detail_container_item_id)
2021: AND wcl.max_load_quantity > 0