APPS.CST_OVHD_RATE_IMPORT_INTERFACE dependencies on MTL_PARAMETERS

Line 60: AND NOT EXISTS (select 1 from mtl_parameters mp

56: error_code = 'CST_INVALID_ORGANIZATION',
57: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ORGANIZATION'),1,240)
58: WHERE cdoi.error_flag is null
59: AND cdoi.group_id = SEQ_NEXTVAL
60: AND NOT EXISTS (select 1 from mtl_parameters mp
61: where NVL(cdoi.organization_id,mp.organization_id) = mp.organization_id
62: AND NVL(cdoi.organization_code,mp.organization_code) = mp.organization_code);
63:
64: l_stmt_no := 30;

Line 71: FROM mtl_parameters mp

67: /*Get the Organization_id from the code */
68:
69: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
70: SET organization_id = (select organization_id
71: FROM mtl_parameters mp
72: WHERE mp.organization_code = cdoi.organization_code
73: AND cdoi.error_flag is null
74: )
75: WHERE cdoi.organization_id is null

Line 94: from mtl_parameters mp

90: 'GMF','GMF_PROCESS_ORG_ERROR'),1,240)
91: WHERE ct.error_flag is null
92: AND ct.group_id = SEQ_NEXTVAL
93: AND EXISTS (select 'This is a process manufacturing org'
94: from mtl_parameters mp
95: where mp.organization_id = ct.organization_id
96: AND NVL(mp.process_enabled_flag, 'N') = 'Y'
97: )
98: ;

Line 132: AND EXISTS (select 1 from MTL_PARAMETERS mp

128: cdoi.error_code = 'CST_NOT_COSTINGORG',
129: cdoi.error_explanation = substrb(fnd_message.get_string('BOM','CST_NOT_COSTINGORG'),1,240)
130: WHERE cdoi.group_id = SEQ_NEXTVAL
131: AND cdoi.error_flag is null
132: AND EXISTS (select 1 from MTL_PARAMETERS mp
133: WHERE mp.cost_organization_id <> mp.organization_id
134: AND mp.organization_id = cdoi.organization_id);
135:
136: l_stmt_no := 65;

Line 539: AND NOT EXISTS (select 1 from mtl_parameters mp

535: error_code = 'CST_INVALID_ORGANIZATION',
536: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ORGANIZATION'),1,240)
537: WHERE croi.error_flag is null
538: AND croi.group_id = SEQ_NEXTVAL
539: AND NOT EXISTS (select 1 from mtl_parameters mp
540: where NVL(croi.organization_id,mp.organization_id) = mp.organization_id
541: AND NVL(croi.organization_code,mp.organization_code) = mp.organization_code);
542:
543: l_stmt_no := 30;

Line 550: FROM mtl_parameters mp

546: /*Get the Organization_id from the code */
547:
548: Update CST_RES_OVERHEADS_INTERFACE croi
549: SET organization_id = (select organization_id
550: FROM mtl_parameters mp
551: WHERE mp.organization_code = croi.organization_code
552: AND croi.error_flag is null
553: )
554: WHERE croi.organization_id is null

Line 589: AND EXISTS (select 1 from MTL_PARAMETERS mp

585: croi.error_code = 'CST_NOT_COSTINGORG',
586: croi.error_explanation = substrb(fnd_message.get_string('BOM','CST_NOT_COSTINGORG'),1,240)
587: WHERE croi.group_id = SEQ_NEXTVAL
588: AND croi.error_flag is null
589: AND EXISTS (select 1 from MTL_PARAMETERS mp
590: WHERE mp.cost_organization_id <> mp.organization_id
591: AND mp.organization_id = croi.organization_id);
592:
593: /* Insert the new cost type into cst_cost_types and assign the new cost types to all the rows */