155: error_code = 'CST_INVALID_RESOURCE',
156: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_RESOURCE'),1,240)
157: WHERE crci.error_flag is null
158: AND crci.group_id = SEQ_NEXTVAL
159: AND NOT EXISTS (select 1 from bom_resources bm
160: WHERE NVL(crci.resource_id,bm.resource_id)=bm.resource_id
161: AND NVL(crci.resource_code,bm.resource_code)=bm.resource_code
162: AND (bm.cost_element_id = 3 OR bm.cost_element_id = 4)
163: AND bm.functional_currency_flag <> 1
168: l_stmt_no := 100;
169:
170:
171: Update CST_RESOURCE_COSTS_INTERFACE crci set
172: crci.resource_id = (select bm.resource_id from bom_resources bm
173: WHERE bm.resource_code = crci.resource_code
174: AND (bm.cost_element_id = 3 or bm.cost_element_id = 4)
175: AND bm.functional_currency_flag <> 1
176: AND bm.organization_id = crci.organization_id)
188: crci.error_code = 'CST_EXP_SUBELEMENT',
189: crci.error_explanation = substrb(fnd_message.get_string('BOM','CST_EXP_SUBELEMENT'),1,240)
190: where crci.error_flag is null
191: AND crci.group_id = SEQ_NEXTVAL
192: AND EXISTS ( select 1 from BOM_RESOURCES bm
193: WHERE bm.organization_id = crci.organization_id
194: AND (bm.cost_element_id = 3 OR bm.cost_element_id = 4)
195: AND bm.resource_id = crci.resource_id
196: AND ((sysdate >= NVL(bm.disable_date,sysdate+1)) OR (bm.allow_costs_flag = 2)));