DBA Data[Home] [Help]

APPS.BOM_CSTRSCCR_XMLP_PKG dependencies on CST_COST_TYPES

Line 253: CST_COST_TYPES

249: DEFAULT_COST_TYPE_ID,
250: ORGANIZATION_ID
251: INTO P_DEFAULT_COST_TYPE_ID,L_ORGANIZATION_ID
252: FROM
253: CST_COST_TYPES
254: WHERE COST_TYPE_ID = P_COST_TYPE_ID;
255: IF (LP_ASSIGNMENT_SET_ID IS NOT NULL AND L_ORGANIZATION_ID IS NOT NULL) THEN
256: /*SRW.MESSAGE(0
257: ,FND_MESSAGE.GET_STRING('BOM'

Line 318: CST_COST_TYPES CCT1,

314: ,CCT2.COST_TYPE),
315: GDCT.USER_CONVERSION_TYPE
316: INTO P_COST_TYPE_NAME,P_BUY_COST_TYPE_NAME,P_CONVERSION_TYPE_NAME
317: FROM
318: CST_COST_TYPES CCT1,
319: CST_COST_TYPES CCT2,
320: GL_DAILY_CONVERSION_TYPES GDCT
321: WHERE CCT1.COST_TYPE_ID = P_COST_TYPE_ID
322: AND CCT2.COST_TYPE_ID = LP_BUY_COST_TYPE_ID

Line 319: CST_COST_TYPES CCT2,

315: GDCT.USER_CONVERSION_TYPE
316: INTO P_COST_TYPE_NAME,P_BUY_COST_TYPE_NAME,P_CONVERSION_TYPE_NAME
317: FROM
318: CST_COST_TYPES CCT1,
319: CST_COST_TYPES CCT2,
320: GL_DAILY_CONVERSION_TYPES GDCT
321: WHERE CCT1.COST_TYPE_ID = P_COST_TYPE_ID
322: AND CCT2.COST_TYPE_ID = LP_BUY_COST_TYPE_ID
323: AND GDCT.CONVERSION_TYPE = P_CONVERSION_TYPE;

Line 835: CST_COST_TYPES

831: SELECT
832: ALTERNATE_BOM_DESIGNATOR
833: INTO L_SNAPSHOT_DESIGNATOR
834: FROM
835: CST_COST_TYPES
836: WHERE COST_TYPE_ID = P_COST_TYPE_ID;
837: IF L_SNAPSHOT_DESIGNATOR IS NOT NULL THEN
838: FOR orgs IN NO_ALT_ORGS(l_snapshot_designator) LOOP
839: SELECT