APPS.BOMPPRCB dependencies on BOM_OPERATION_RESOURCES

Line 717: table_name := 'BOM_OPERATION_RESOURCES';

713: /*
714: ** Process operation resources interface table
715: */
716: stmt_num := 90;
717: table_name := 'BOM_OPERATION_RESOURCES';
718: insert into BOM_OPERATION_RESOURCES
719: (
720: OPERATION_SEQUENCE_ID,
721: RESOURCE_SEQ_NUM,

Line 718: insert into BOM_OPERATION_RESOURCES

714: ** Process operation resources interface table
715: */
716: stmt_num := 90;
717: table_name := 'BOM_OPERATION_RESOURCES';
718: insert into BOM_OPERATION_RESOURCES
719: (
720: OPERATION_SEQUENCE_ID,
721: RESOURCE_SEQ_NUM,
722: RESOURCE_ID ,

Line 2186: table_name := 'BOM_OPERATION_RESOURCES';

2182: /*
2183: ** Process operation resources interface table
2184: */
2185: stmt_num := 40;
2186: table_name := 'BOM_OPERATION_RESOURCES';
2187: loop
2188: insert into BOM_OPERATION_RESOURCES
2189: (
2190: OPERATION_SEQUENCE_ID,

Line 2188: insert into BOM_OPERATION_RESOURCES

2184: */
2185: stmt_num := 40;
2186: table_name := 'BOM_OPERATION_RESOURCES';
2187: loop
2188: insert into BOM_OPERATION_RESOURCES
2189: (
2190: OPERATION_SEQUENCE_ID,
2191: RESOURCE_SEQ_NUM,
2192: RESOURCE_ID,

Line 2275: and exists (select NULL from bom_operation_resources bor

2271:
2272: update bom_op_resources_interface bri
2273: set process_flag = 7
2274: where process_flag = 4
2275: and exists (select NULL from bom_operation_resources bor
2276: where bor.operation_sequence_id =
2277: bri.operation_sequence_id
2278: and bor.resource_seq_num =
2279: bri.resource_seq_num);