APPS.CST_ITEM_COST_IMPORT_INTERFACE dependencies on MTL_PARAMETERS

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

44: error_code = 'CST_INVALID_ORGANIZATION',
45: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ORGANIZATION'),1,240)
46: WHERE ct.error_flag is null
47: AND ct.group_id = SEQ_NEXTVAL
48: AND NOT EXISTS (select 1 from mtl_parameters mp
49: where (NVL(ct.organization_id,mp.organization_id) = mp.organization_id)
50: AND (NVL(ct.organization_code,mp.organization_code) = mp.organization_code)
51: );
52:

Line 57: /* Select the corresponding organization_id from mtl_parameters given the

53: l_stmt_no := 30;
54:
55: fnd_file.put_line(fnd_file.log, 'after checking for organization_id validity');
56:
57: /* Select the corresponding organization_id from mtl_parameters given the
58: organization code.*/
59:
60: Update CST_ITEM_CST_DTLS_INTERFACE ct
61: SET organization_id = (select organization_id

Line 62: FROM mtl_parameters mp

58: organization code.*/
59:
60: Update CST_ITEM_CST_DTLS_INTERFACE ct
61: SET organization_id = (select organization_id
62: FROM mtl_parameters mp
63: WHERE mp.organization_code = ct.organization_code
64: )
65: WHERE ct.organization_id is null
66: AND ct.error_flag is null

Line 84: from mtl_parameters mp

80: 'GMF','GMF_PROCESS_ORG_ERROR'),1,240)
81: WHERE ct.error_flag is null
82: AND ct.group_id = SEQ_NEXTVAL
83: AND EXISTS (select 'This is a process manufacturing org'
84: from mtl_parameters mp
85: where mp.organization_id = ct.organization_id
86: AND NVL(mp.process_enabled_flag, 'N') = 'Y'
87: )
88: ;

Line 120: AND EXISTS (Select 1 from MTL_PARAMETERS mp

116: ct.error_code = 'CST_NOT_COSTINGORG',
117: ct.error_explanation = substrb(fnd_message.get_string('BOM','CST_NOT_COSTINGORG'),1,240)
118: WHERE ct.group_id = SEQ_NEXTVAL
119: AND ct.error_flag is null
120: AND EXISTS (Select 1 from MTL_PARAMETERS mp
121: WHERE mp.cost_organization_id <> mp.organization_id
122: AND mp.organization_id = ct.organization_id );
123:
124: l_stmt_no := 61;

Line 298: resource_id = (Select Decode(ct.cost_element_id,1,mp.default_material_cost_id,null) from mtl_parameters mp where mp.organization_id = ct.organization_id)

294: /* Now start setting the resource id to corresponding default id */
295:
296:
297: Update CST_ITEM_CST_DTLS_INTERFACE ct set
298: resource_id = (Select Decode(ct.cost_element_id,1,mp.default_material_cost_id,null) from mtl_parameters mp where mp.organization_id = ct.organization_id)
299: WHERE error_flag is null
300: AND ct.group_id = SEQ_NEXTVAL
301: AND (ct.resource_id is null AND ct.resource_code is null);
302: