eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_OPERATIONAL_ROUTINGS

Line 44: | into bom_operational_routings

Line 2293: select bom_operational_routings_s.nextval

2289: WriteToLog('Model Does not have a routing ',1);
2290: GOTO ROUTING;
2291: end if;
2292:
2293: select bom_operational_routings_s.nextval
2294: into lCfgRtgId
2295: from dual;
2296:
2297: xTableName := 'BOM_OPERATIONAL_ROUTING';

Line 2300: WriteToLog('Inserting the routing header information into bom_operational_routings..',5);

2296:
2297: xTableName := 'BOM_OPERATIONAL_ROUTING';
2298: lStmtNum := 30;
2299:
2300: WriteToLog('Inserting the routing header information into bom_operational_routings..',5);
2301:
2302: insert into bom_operational_routings
2303: (
2304: routing_sequence_id,

Line 2302: insert into bom_operational_routings

2298: lStmtNum := 30;
2299:
2300: WriteToLog('Inserting the routing header information into bom_operational_routings..',5);
2301:
2302: insert into bom_operational_routings
2303: (
2304: routing_sequence_id,
2305: assembly_item_id,
2306: organization_id,

Line 2393: bom_operational_routings bor,

2389: bor.ctp_flag,
2390: bor.project_id,
2391: bor.task_id
2392: from
2393: bom_operational_routings bor,
2394: mtl_parameters mp
2395: where bor.assembly_item_id = pModelId
2396: and bor.organization_id = pOrgId
2397: and bor.alternate_routing_designator is null

Line 2411: update bom_operational_routings b

2407: +----------------------------------------------------------------*/
2408:
2409: lStmtNum := 40;
2410:
2411: update bom_operational_routings b
2412: set mixed_model_map_flag =
2413: ( select 1
2414: from bom_operational_routings bor
2415: where bor.assembly_item_id = pModelId

Line 2414: from bom_operational_routings bor

2410:
2411: update bom_operational_routings b
2412: set mixed_model_map_flag =
2413: ( select 1
2414: from bom_operational_routings bor
2415: where bor.assembly_item_id = pModelId
2416: and bor.organization_id = pOrgId
2417: and bor.cfm_routing_flag = 1
2418: and bor.mixed_model_map_flag = 1

Line 2465: bom_operational_routings or1,

2461: l_batch_id
2462: from
2463: bom_cto_order_lines_upg bcol1,
2464: mtl_system_items si1,
2465: bom_operational_routings or1,
2466: bom_operation_sequences os1
2467: where bcol1.line_id = pLineId
2468: and bcol1.inventory_item_id = pModelId
2469: and si1.organization_id = pOrgId -- this is the mfg org from src_orgs

Line 2501: bom_operational_routings or1,

2497: bom_cto_order_lines_upg bcol2, -- parent models or option classes
2498: mtl_system_items msi,
2499: bom_inventory_components ic1,
2500: bom_bill_of_materials b1,
2501: bom_operational_routings or1,
2502: bom_operation_sequences os1
2503: where bcol1.parent_ato_line_id = pLineId /*AP*/
2504: and bcol1.item_type_code in ('CLASS','OPTION') /* OC and Option items */
2505: and bcol1.line_id <> bcol2.line_id

Line 2562: bom_operational_routings or1,

2558: os1.routing_sequence_id,
2559: l_batch_id
2560: from
2561: bom_operation_sequences os1,
2562: bom_operational_routings or1,
2563: mtl_system_items si2,
2564: bom_inventory_components ic1,
2565: bom_bill_of_materials b1,
2566: mtl_system_items si1

Line 2889: bom_operational_routings or1,

2885: os1.routing_sequence_id
2886: from
2887: mtl_system_items si1,
2888: bom_cto_order_lines_upg bcol,
2889: bom_operational_routings or1,
2890: bom_operation_sequences os1
2891: where bcol.parent_ato_line_id = pLineId
2892: and si1.organization_id = pOrgId
2893: and si1.inventory_item_id = bcol.inventory_item_id

Line 2921: bom_operational_routings or1,

2917: bom_cto_order_lines_upg bcol1, /* components */
2918: bom_cto_order_lines_upg bcol2, /* parents model */
2919: bom_inventory_components ic1,
2920: bom_bill_of_materials b1,
2921: bom_operational_routings or1,
2922: bom_operation_sequences os1
2923: where bcol1.parent_ato_line_id = pLineId
2924: and bcol1.item_type_code in ('CLASS','OPTION')
2925: and bcol2.parent_ato_line_id = pLineId

Line 2979: bom_operational_routings or1,

2975: nvl(os1.operation_type,1),
2976: os1.routing_sequence_id
2977: from
2978: bom_operation_sequences os1,
2979: bom_operational_routings or1,
2980: mtl_system_items si2,
2981: bom_inventory_components ic1,
2982: bom_bill_of_materials b1,
2983: mtl_system_items si1,

Line 3306: xTableName := 'BOM_OPERATIONAL_ROUTINGS';

3302: there is no operation associated with the routing
3303: +-----------------------------------------------------------*/
3304:
3305: lStmtNum := 120;
3306: xTableName := 'BOM_OPERATIONAL_ROUTINGS';
3307:
3308: delete from BOM_OPERATIONAL_ROUTINGS b1
3309: where b1.routing_sequence_id not in
3310: (select routing_sequence_id

Line 3308: delete from BOM_OPERATIONAL_ROUTINGS b1

3304:
3305: lStmtNum := 120;
3306: xTableName := 'BOM_OPERATIONAL_ROUTINGS';
3307:
3308: delete from BOM_OPERATIONAL_ROUTINGS b1
3309: where b1.routing_sequence_id not in
3310: (select routing_sequence_id
3311: from bom_operation_sequences )
3312: and b1.routing_sequence_id = lCfgRtgId;

Line 3335: bom_operational_routings bor

3331: where not exists
3332: (select 'op seq exists in config routing'
3333: from
3334: bom_operation_sequences bos,
3335: bom_operational_routings bor
3336: where bos.operation_seq_num = ci.operation_seq_num
3337: and bos.routing_sequence_id = bor.routing_sequence_id
3338: and bor.assembly_item_id = pConfigId
3339: and bor.organization_id = pOrgId

Line 3379: from bom_operational_routings

3375:
3376: lstmtNum := 410;
3377: select nvl(cfm_routing_flag,2)
3378: into lCfmRtgFlag
3379: from bom_operational_routings
3380: where routing_sequence_id = lCfgrtgId;
3381:
3382:
3383: --

Line 3460: from bom_operational_routings

3456: --will select serial start op of model, only if effective on the day
3457: --as routing generation takes care of eefectivity, we check if op seq is present in config routing
3458: select serialization_start_op
3459: into l_ser_start_op
3460: from bom_operational_routings
3461: where assembly_item_id = pModelId
3462: and alternate_routing_designator is null
3463: and organization_id = pOrgId
3464: and serialization_start_op in

Line 3482: update bom_operational_routings

3478: lstmtNum := 413;
3479: WriteToLog('Before updating config routing with serial start op of option class', 4);
3480:
3481: begin
3482: update bom_operational_routings
3483: set serialization_start_op =
3484: ( select min( serialization_start_op)
3485: from bom_operational_routings
3486: where organization_id = pOrgId

Line 3485: from bom_operational_routings

3481: begin
3482: update bom_operational_routings
3483: set serialization_start_op =
3484: ( select min( serialization_start_op)
3485: from bom_operational_routings
3486: where organization_id = pOrgId
3487: and alternate_routing_designator is null
3488: and assembly_item_id in
3489: ( select component_item_id

Line 3515: update bom_operational_routings

3511:
3512: else --model has serial start op seq
3513:
3514: lstmtNum := 414;
3515: update bom_operational_routings
3516: set serialization_start_op = l_ser_start_op
3517: where routing_sequence_id = lCfgRtgId ;
3518:
3519: WriteToLog('Updated with serial start op of model, serial start op =>'||l_ser_start_op , 4);

Line 5198: from bom_operational_routings bor,

5194: NULL, /* ATTRIBUTE12 */
5195: NULL, /* ATTRIBUTE13 */
5196: NULL, /* ATTRIBUTE14 */
5197: NULL /* ATTRIBUTE15 */
5198: from bom_operational_routings bor,
5199: mtl_parameters mp,
5200: bom_cto_order_lines_upg bcolu
5201: where bcolu.sequence = p_seq
5202: and bcolu.status = 'BOM_LOOP'

Line 5313: bom_operational_routings bor1

5309: from
5310: bom_operation_sequences osi,
5311: bom_operation_resources bor,
5312: bom_cto_order_lines_upg bcolu,
5313: bom_operational_routings bor1
5314: where bcolu.sequence = p_seq
5315: and bcolu.status = 'BOM_LOOP'
5316: and bcolu.config_item_id = bor1.assembly_item_id
5317: and osi.routing_sequence_id = bor1.routing_sequence_id

Line 5431: bom_operational_routings bor

5427: from
5428: bom_operation_sequences osi,
5429: bom_sub_operation_resources bsor,
5430: bom_cto_order_lines_upg bcolu,
5431: bom_operational_routings bor
5432: where bcolu.sequence = p_seq
5433: and bcolu.status = 'BOM_LOOP'
5434: and bcolu.config_item_id = bor.assembly_item_id
5435: and osi.routing_sequence_id = bor.routing_sequence_id

Line 5518: bom_operational_routings brif,

5514: bom_operation_sequences bos1, /* 'from' Ops of model */
5515: bom_operation_sequences bos2, /* 'to' Ops of model */
5516: bom_operation_sequences bos3, /* 'from' Ops of config */
5517: bom_operation_sequences bos4, /* 'to' Ops of config */
5518: bom_operational_routings brif,
5519: bom_cto_order_lines_upg bcolu
5520: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
5521: AND bon.to_op_seq_id = bos2.operation_sequence_id
5522: AND bos1.routing_sequence_id = bos2.routing_sequence_id

Line 5537: from bom_operational_routings bor,

5533: AND bos4.operation_seq_num = bos2.operation_seq_num
5534: AND NVL(bos4.operation_type,1) = NVL(bos2.operation_type, 1)
5535: AND bos1.routing_sequence_id = ( /* find the model routing */
5536: select routing_sequence_id
5537: from bom_operational_routings bor,
5538: mtl_system_items msi
5539: where brif.assembly_item_id = msi.inventory_item_id
5540: and brif.organization_id = msi.organization_id
5541: and bor.assembly_item_id = msi.base_item_id

Line 6896: from bom_operational_routings

6892: select routing_sequence_id,
6893: NVL(cfm_routing_flag,2)
6894: into xRtgId,
6895: xRtgType
6896: from bom_operational_routings
6897: where assembly_item_id = pItemId
6898: and organization_id = pOrgId
6899: and alternate_routing_designator is null;
6900: