APPS.CST_OVHD_RATE_IMPORT_INTERFACE dependencies on BOM_RESOURCES

Line 218: AND NOT EXISTS (select 1 from bom_resources bm

214: error_code = 'CST_INVALID_OVERHEAD',
215: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_OVERHEAD'),1,240)
216: WHERE cdoi.error_flag is null
217: AND cdoi.group_id = SEQ_NEXTVAL
218: AND NOT EXISTS (select 1 from bom_resources bm
219: WHERE NVL(cdoi.overhead_id,bm.resource_id)=bm.resource_id
220: AND NVL(cdoi.overhead,bm.resource_code)=bm.resource_code
221: AND (bm.cost_element_id = 5)
222: AND cdoi.organization_id = bm.organization_id

Line 229: set cdoi.overhead_id = (select bm.resource_id from bom_resources bm

225: l_stmt_no := 140;
226: fnd_file.put_line(fnd_file.log,'done checking for invalid overhead ID and overhead');
227:
228: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
229: set cdoi.overhead_id = (select bm.resource_id from bom_resources bm
230: WHERE cdoi.overhead = bm.resource_code
231: AND bm.organization_id = cdoi.organization_id
232: AND (bm.cost_element_id = 5)
233: )

Line 249: AND EXISTS (select 1 from BOM_RESOURCES bm

245: cdoi.error_code = 'CST_EXP_SUBELEMENT',
246: cdoi.error_explanation = substrb(fnd_message.get_string('BOM','CST_EXP_SUBELEMENT'),1,240)
247: WHERE cdoi.error_flag is null
248: AND cdoi.group_id = SEQ_NEXTVAL
249: AND EXISTS (select 1 from BOM_RESOURCES bm
250: where bm.organization_id = cdoi.organization_id
251: AND bm.resource_id = cdoi.overhead_id
252: AND ((sysdate >= NVL(bm.disable_date,sysdate+1)) OR (bm.allow_costs_flag = 2)));
253:

Line 643: AND NOT EXISTS (select 1 from bom_resources bm

639: error_code = 'CST_INVALID_SUBELEMENT',
640: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_SUBELEMENT'),1,240)
641: WHERE croi.error_flag is null
642: AND croi.group_id = SEQ_NEXTVAL
643: AND NOT EXISTS (select 1 from bom_resources bm
644: WHERE NVL(croi.resource_id,bm.resource_id)=bm.resource_id
645: AND NVL(croi.resource_code,bm.resource_code)=bm.resource_code
646: AND (bm.cost_element_id = 3 OR bm.cost_element_id = 4)
647: AND croi.organization_id = bm.organization_id

Line 656: set croi.resource_id = (select bm.resource_id from bom_resources bm

652:
653: /* Get the resource_id from the resource_code */
654:
655: Update CST_RES_OVERHEADS_INTERFACE croi
656: set croi.resource_id = (select bm.resource_id from bom_resources bm
657: WHERE croi.resource_code = bm.resource_code
658: AND bm.organization_id = croi.organization_id
659: AND (bm.cost_element_id = 3 OR bm.cost_element_id = 4)
660: )

Line 675: AND exists (select 1 from BOM_RESOURCES bm

671: croi.error_code = 'CST_EXP_SUBELEMENT',
672: croi.error_explanation = substrb(fnd_message.get_string('BOM','CST_EXP_SUBELEMENT'),1,240)
673: WHERE croi.error_flag is null
674: AND croi.group_id = SEQ_NEXTVAl
675: AND exists (select 1 from BOM_RESOURCES bm
676: WHERE bm.organization_id = croi.organization_id
677: AND bm.resource_id = croi.resource_id
678: AND ((sysdate >= NVL(bm.disable_date,sysdate+1)) OR (bm.allow_costs_flag = 2)));
679:

Line 689: AND NOT EXISTS (select 1 from bom_resources bm

685: error_code = 'CST_INVALID_OVERHEAD',
686: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_OVERHEAD'),1,240)
687: WHERE croi.error_flag is null
688: AND croi.group_id = SEQ_NEXTVAL
689: AND NOT EXISTS (select 1 from bom_resources bm
690: WHERE NVL(croi.overhead_id,bm.resource_id)=bm.resource_id
691: AND NVL(croi.overhead,bm.resource_code)=bm.resource_code
692: AND (bm.cost_element_id = 5 OR bm.cost_element_id = 2)
693: AND croi.organization_id = bm.organization_id

Line 702: set croi.overhead_id = (select bm.resource_id from bom_resources bm

698:
699: /* Get the overhead_id from the overhead */
700:
701: Update CST_RES_OVERHEADS_INTERFACE croi
702: set croi.overhead_id = (select bm.resource_id from bom_resources bm
703: WHERE croi.overhead = bm.resource_code
704: AND bm.organization_id = croi.organization_id
705: AND (bm.cost_element_id = 5 OR bm.cost_element_id = 2)
706: )

Line 721: AND exists (select 1 from BOM_RESOURCES bm

717: croi.error_code = 'CST_EXP_SUBELEMENT',
718: croi.error_explanation = substrb(fnd_message.get_string('BOM','CST_EXP_SUBELEMENT'),1,240)
719: WHERE croi.error_flag is null
720: AND croi.group_id = SEQ_NEXTVAL
721: AND exists (select 1 from BOM_RESOURCES bm
722: WHERE bm.organization_id = croi.organization_id
723: AND bm.resource_id = croi.overhead_id
724: AND ((sysdate >= NVL(bm.disable_date,sysdate+1)) OR (bm.allow_costs_flag = 2))) ;
725: