[Home] [Help]
234: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_SUBELEMENT'),1,240)
235: WHERE error_flag is null
236: AND ct.group_id = SEQ_NEXTVAL
237: AND (ct.resource_id is NOT NULL OR ct.resource_code is not null)
238: AND NOT EXISTS (select 1 from bom_resources bm
239: WHERE NVL(ct.resource_id,bm.resource_id)=bm.resource_id
240: AND NVL(ct.resource_code,bm.resource_code)=bm.resource_code
241: AND ct.cost_element_id = bm.cost_element_id
242: AND ct.organization_id = bm.organization_id
245: l_stmt_no := 160;
246:
247:
248: Update CST_ITEM_CST_DTLS_INTERFACE ct
249: set ct.resource_id = (select bm.resource_id from bom_resources bm
250: WHERE ct.resource_code = bm.resource_code
251: AND bm.organization_id = ct.organization_id
252: AND ct.cost_element_id = bm.cost_element_id
253: )
324: ct.error_code = 'CST_EXP_SUBELEMENT',
325: ct.error_explanation = substrb(fnd_message.get_string('BOM','CST_EXP_SUBELEMENT'),1,240)
326: where ct.error_flag is null
327: AND ct.group_id = SEQ_NEXTVAL
328: AND EXISTS (select 1 from BOM_RESOURCES bm
329: where bm.organization_id = ct.organization_id
330: AND bm.cost_element_id = ct.cost_element_id
331: AND bm.resource_id = ct.resource_id
332: AND ((sysdate >= NVL(bm.disable_date,sysdate+1)) OR (bm.allow_costs_flag = 2)));
344: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_FUNCCODE'),1,240)
345: WHERE error_flag is null
346: AND ct.group_id = SEQ_NEXTVAL
347: AND ct.cost_element_id IN (3,4)
348: AND NOT EXISTS (select 1 from bom_resources bm
349: where bm.functional_currency_flag = 1
350: AND bm.resource_id = ct.resource_id
351: AND bm.cost_element_id = ct.cost_element_id
352: AND bm.organization_id = ct.organization_id