DBA Data[Home] [Help]

APPS.BOM_CSTRSCCR_XMLP_PKG dependencies on CST_COST_TYPES

Line 261: CST_COST_TYPES

257: DEFAULT_COST_TYPE_ID,
258: ORGANIZATION_ID
259: INTO P_DEFAULT_COST_TYPE_ID,L_ORGANIZATION_ID
260: FROM
261: CST_COST_TYPES
262: WHERE COST_TYPE_ID = LP_COST_TYPE_ID;
263: IF (LP_ASSIGNMENT_SET_ID IS NOT NULL AND L_ORGANIZATION_ID IS NOT NULL) THEN
264: /*SRW.MESSAGE(0
265: ,FND_MESSAGE.GET_STRING('BOM'

Line 326: CST_COST_TYPES CCT1,

322: ,CCT2.COST_TYPE),
323: GDCT.USER_CONVERSION_TYPE
324: INTO P_COST_TYPE_NAME,P_BUY_COST_TYPE_NAME,P_CONVERSION_TYPE_NAME
325: FROM
326: CST_COST_TYPES CCT1,
327: CST_COST_TYPES CCT2,
328: GL_DAILY_CONVERSION_TYPES GDCT
329: WHERE CCT1.COST_TYPE_ID = LP_COST_TYPE_ID
330: AND CCT2.COST_TYPE_ID = LP_BUY_COST_TYPE_ID

Line 327: CST_COST_TYPES CCT2,

323: GDCT.USER_CONVERSION_TYPE
324: INTO P_COST_TYPE_NAME,P_BUY_COST_TYPE_NAME,P_CONVERSION_TYPE_NAME
325: FROM
326: CST_COST_TYPES CCT1,
327: CST_COST_TYPES CCT2,
328: GL_DAILY_CONVERSION_TYPES GDCT
329: WHERE CCT1.COST_TYPE_ID = LP_COST_TYPE_ID
330: AND CCT2.COST_TYPE_ID = LP_BUY_COST_TYPE_ID
331: AND GDCT.CONVERSION_TYPE = P_CONVERSION_TYPE;

Line 843: CST_COST_TYPES

839: SELECT
840: ALTERNATE_BOM_DESIGNATOR
841: INTO L_SNAPSHOT_DESIGNATOR
842: FROM
843: CST_COST_TYPES
844: WHERE COST_TYPE_ID = LP_COST_TYPE_ID;
845: IF L_SNAPSHOT_DESIGNATOR IS NOT NULL THEN
846: FOR orgs IN NO_ALT_ORGS(l_snapshot_designator) LOOP
847: SELECT