DBA Data[Home] [Help]

APPS.WSM_WLT_VALIDATE_PVT dependencies on MTL_PARAMETERS

Line 810: from mtl_parameters

806: -- ST : Performance bug fix 4914162 : Remove the use of org_organization_definitions.
807: select organization_code
808: into p_wltx_header.organization_code
809: -- from org_organization_definitions
810: from mtl_parameters
811: where (organization_id = p_wltx_header.organization_id );
812:
813: if( g_log_level_statement >= l_log_level ) then
814: l_msg_tokens.delete;

Line 831: from mtl_parameters

827: -- ST : Performance bug fix 4914162 : Remove the use of org_organization_definitions.
828: select organization_id
829: into p_wltx_header.organization_id
830: -- from org_organization_definitions
831: from mtl_parameters
832: -- where (organization_name = p_wltx_header.organization_code)
833: where organization_code = p_wltx_header.organization_code
834: and organization_id = nvl(p_wltx_header.organization_id,organization_id);
835:

Line 6667: mtl_parameters mp

6663: l_restrict_loc_code,
6664: l_item_loc_control
6665: from mtl_system_items ms,
6666: mtl_secondary_inventories msi,
6667: mtl_parameters mp
6668: where mp.organization_id = p_organization_id
6669: and ms.organization_id = p_organization_id
6670: and ms.inventory_item_id = l_rtg_item_id -- p_primary_item_id
6671: and msi.secondary_inventory_name = p_rj_completion_subinventory