DBA Data[Home] [Help]

APPS.CSTPCINT dependencies on MTL_PARAMETERS

Line 22: FROM MTL_PARAMETERS MP

18: UPDATE CST_ITEM_COSTS_INTERFACE CICI
19: SET
20: CICI.ORGANIZATION_ID = (
21: SELECT MP.ORGANIZATION_ID
22: FROM MTL_PARAMETERS MP
23: WHERE MP.ORGANIZATION_CODE = CICI.ORGANIZATION_CODE
24: )
25: WHERE CICI.GROUP_ID = i_group_id;
26:

Line 75: FROM MTL_PARAMETERS MP

71: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI
72: SET
73: CICDI.ORGANIZATION_ID = (
74: SELECT MP.ORGANIZATION_ID
75: FROM MTL_PARAMETERS MP
76: WHERE MP.ORGANIZATION_CODE = CICDI.ORGANIZATION_CODE
77: )
78: WHERE CICDI.GROUP_ID = i_group_id;
79:

Line 179: from mtl_parameters mp,wsm_parameters wsm

175:
176: /* If destination organization is not wsm enabled, then leave yielded cost as null */
177: select count(*)
178: into l_to_wsm_flag
179: from mtl_parameters mp,wsm_parameters wsm
180: where wsm.organization_id = i_to_org_id
181: and mp.organization_id = wsm.organization_id
182: and UPPER(mp.wsm_enabled_flag) = 'Y';
183: