APPS.CST_RES_COST_IMPORT_INTERFACE dependencies on MTL_PARAMETERS

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

40: error_code = 'CST_INVALID_ORGANIZATION',
41: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ORGANIZATION'),1,240)
42: WHERE crci.error_flag is null
43: AND crci.group_id = SEQ_NEXTVAL
44: AND NOT EXISTS (select 1 from mtl_parameters mp
45: where NVL(crci.organization_id,mp.organization_id) = mp.organization_id
46: AND NVL(crci.organization_code,mp.organization_code) = mp.organization_code
47: );
48:

Line 56: FROM mtl_parameters mp

52: /* Get the organization_id from the code */
53:
54: Update CST_RESOURCE_COSTS_INTERFACE crci
55: SET organization_id = (select organization_id
56: FROM mtl_parameters mp
57: WHERE mp.organization_code = crci.organization_code
58: )
59: WHERE crci.organization_id is null
60: AND crci.error_flag is null

Line 78: from mtl_parameters mp

74: 'GMF','GMF_PROCESS_ORG_ERROR'),1,240)
75: WHERE ct.error_flag is null
76: AND ct.group_id = SEQ_NEXTVAL
77: AND EXISTS (select 'This is a process manufacturing org'
78: from mtl_parameters mp
79: where mp.organization_id = ct.organization_id
80: AND NVL(mp.process_enabled_flag, 'N') = 'Y'
81: )
82: ;

Line 117: AND EXISTS ( Select 1 from mtl_parameters mp

113: crci.Error_code = 'CST_NOT_COSTINGORG',
114: crci.Error_explanation = substrb(fnd_message.get_string('BOM','CST_NOT_COSTINGORG'),1,240)
115: WHERE crci.group_id = SEQ_NEXTVAL
116: AND crci.error_flag is null
117: AND EXISTS ( Select 1 from mtl_parameters mp
118: WHERE mp.cost_organization_id <> mp.organization_id
119: AND mp.organization_id = crci.organization_id);
120:
121: l_stmt_no := 55;