DBA Data[Home] [Help]

APPS.WSMPVLDT dependencies on MTL_PARAMETERS

Line 1618: from mtl_parameters mtl

1614: select null into l_dummy
1615: from wsm_parameters para
1616: where para.organization_id = l_cur_wsmti_rec.organization_id
1617: and exists ( select null
1618: from mtl_parameters mtl
1619: where mtl.organization_id = para.organization_id)
1620: and trunc(nvl(l_cur_wsmti_rec.transaction_date, sysdate)) <
1621: (select nvl(disable_date, sysdate + 1)
1622: from org_organization_definitions org

Line 8356: mtl_parameters MP

8352: INTO l_sub_loc_control, l_org_loc_control,
8353: l_restrict_locators_code, l_item_loc_control
8354: FROM mtl_system_items MS,
8355: mtl_secondary_inventories MSUB,
8356: mtl_parameters MP
8357: WHERE MP.organization_id = l_organization_id
8358: AND MS.organization_id = l_organization_id
8359: AND MS.inventory_item_id = l_primary_item_id
8360: AND MSUB.secondary_inventory_name = l_comp_sub_inv_r