APPS.WSMPLCVA dependencies on MTL_PARAMETERS

Line 24: --from MTL_PARAMETERS MP , WSM_PARAMETERS WSM, ORG_ORGANIZATION_DEFINITIONS ORG

20: wsm.ESTIMATED_SCRAP_ACCOUNTING,
21: NULL,
22: NULL,
23: wp.po_creation_time
24: --from MTL_PARAMETERS MP , WSM_PARAMETERS WSM, ORG_ORGANIZATION_DEFINITIONS ORG
25: from MTL_PARAMETERS MP , WSM_PARAMETERS WSM, HR_ALL_ORGANIZATION_UNITS ORG, WIP_PARAMETERS WP
26: where MP.ORGANIZATION_ID = WSM.ORGANIZATION_ID
27: and ORG.ORGANIZATION_ID = WSM.ORGANIZATION_ID
28: and WP.ORGANIZATION_ID = WSM.ORGANIZATION_ID

Line 25: from MTL_PARAMETERS MP , WSM_PARAMETERS WSM, HR_ALL_ORGANIZATION_UNITS ORG, WIP_PARAMETERS WP

21: NULL,
22: NULL,
23: wp.po_creation_time
24: --from MTL_PARAMETERS MP , WSM_PARAMETERS WSM, ORG_ORGANIZATION_DEFINITIONS ORG
25: from MTL_PARAMETERS MP , WSM_PARAMETERS WSM, HR_ALL_ORGANIZATION_UNITS ORG, WIP_PARAMETERS WP
26: where MP.ORGANIZATION_ID = WSM.ORGANIZATION_ID
27: and ORG.ORGANIZATION_ID = WSM.ORGANIZATION_ID
28: and WP.ORGANIZATION_ID = WSM.ORGANIZATION_ID
29: and UPPER(MP.WSM_ENABLED_FLAG)='Y'

Line 66: FROM mtl_parameters

62: -- END: BUG3126650
63:
64: SELECT max(stock_locator_control_code)
65: INTO v_org(v_index).MAX_STK_LOC_CNTRL
66: FROM mtl_parameters
67: WHERE organization_id = v_index;
68:
69: v_index := v_org.next(v_index);
70: end loop;