[Home] [Help]
229: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_SUBELEMENT'),1,240)
230: WHERE error_flag is null
231: AND ct.group_id = SEQ_NEXTVAL
232: AND (ct.resource_id is NOT NULL OR ct.resource_code is not null)
233: AND NOT EXISTS (select 1 from bom_resources bm
234: WHERE NVL(ct.resource_id,bm.resource_id)=bm.resource_id
235: AND NVL(ct.resource_code,bm.resource_code)=bm.resource_code
236: AND ct.cost_element_id = bm.cost_element_id
237: AND ct.organization_id = bm.organization_id
240: l_stmt_no := 160;
241:
242:
243: Update CST_ITEM_CST_DTLS_INTERFACE ct
244: set ct.resource_id = (select bm.resource_id from bom_resources bm
245: WHERE ct.resource_code = bm.resource_code
246: AND bm.organization_id = ct.organization_id
247: AND ct.cost_element_id = bm.cost_element_id
248: )
319: ct.error_code = 'CST_EXP_SUBELEMENT',
320: ct.error_explanation = substrb(fnd_message.get_string('BOM','CST_EXP_SUBELEMENT'),1,240)
321: where ct.error_flag is null
322: AND ct.group_id = SEQ_NEXTVAL
323: AND EXISTS (select 1 from BOM_RESOURCES bm
324: where bm.organization_id = ct.organization_id
325: AND bm.cost_element_id = ct.cost_element_id
326: AND bm.resource_id = ct.resource_id
327: AND ((sysdate >= NVL(bm.disable_date,sysdate+1)) OR (bm.allow_costs_flag = 2)));
339: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_FUNCCODE'),1,240)
340: WHERE error_flag is null
341: AND ct.group_id = SEQ_NEXTVAL
342: AND ct.cost_element_id IN (3,4)
343: AND NOT EXISTS (select 1 from bom_resources bm
344: where bm.functional_currency_flag = 1
345: AND bm.resource_id = ct.resource_id
346: AND bm.cost_element_id = ct.cost_element_id
347: AND bm.organization_id = ct.organization_id