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 2382: select bom_operational_routings_s.nextval

2378: WriteToLog('Model Does not have a routing ',1);
2379: GOTO ROUTING;
2380: end if;
2381:
2382: select bom_operational_routings_s.nextval
2383: into lCfgRtgId
2384: from dual;
2385:
2386: xTableName := 'BOM_OPERATIONAL_ROUTING';

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

2385:
2386: xTableName := 'BOM_OPERATIONAL_ROUTING';
2387: lStmtNum := 30;
2388:
2389: WriteToLog('Inserting the routing header information into bom_operational_routings..',5);
2390:
2391: insert into bom_operational_routings
2392: (
2393: routing_sequence_id,

Line 2391: insert into bom_operational_routings

2387: lStmtNum := 30;
2388:
2389: WriteToLog('Inserting the routing header information into bom_operational_routings..',5);
2390:
2391: insert into bom_operational_routings
2392: (
2393: routing_sequence_id,
2394: assembly_item_id,
2395: organization_id,

Line 2482: bom_operational_routings bor,

2478: bor.ctp_flag,
2479: bor.project_id,
2480: bor.task_id
2481: from
2482: bom_operational_routings bor,
2483: mtl_parameters mp
2484: where bor.assembly_item_id = pModelId
2485: and bor.organization_id = pOrgId
2486: and bor.alternate_routing_designator is null

Line 2500: update bom_operational_routings b

2496: +----------------------------------------------------------------*/
2497:
2498: lStmtNum := 40;
2499:
2500: update bom_operational_routings b
2501: set mixed_model_map_flag =
2502: ( select 1
2503: from bom_operational_routings bor
2504: where bor.assembly_item_id = pModelId

Line 2503: from bom_operational_routings bor

2499:
2500: update bom_operational_routings b
2501: set mixed_model_map_flag =
2502: ( select 1
2503: from bom_operational_routings bor
2504: where bor.assembly_item_id = pModelId
2505: and bor.organization_id = pOrgId
2506: and bor.cfm_routing_flag = 1
2507: and bor.mixed_model_map_flag = 1

Line 2554: bom_operational_routings or1,

2550: l_batch_id
2551: from
2552: bom_cto_order_lines_upg bcol1,
2553: mtl_system_items si1,
2554: bom_operational_routings or1,
2555: bom_operation_sequences os1
2556: where bcol1.line_id = pLineId
2557: and bcol1.inventory_item_id = pModelId
2558: and si1.organization_id = pOrgId -- this is the mfg org from src_orgs

Line 2590: bom_operational_routings or1,

2586: bom_cto_order_lines_upg bcol2, -- parent models or option classes
2587: mtl_system_items msi,
2588: bom_inventory_components ic1,
2589: bom_bill_of_materials b1,
2590: bom_operational_routings or1,
2591: bom_operation_sequences os1
2592: where bcol1.parent_ato_line_id = pLineId /*AP*/
2593: and bcol1.item_type_code in ('CLASS','OPTION') /* OC and Option items */
2594: and bcol1.line_id <> bcol2.line_id

Line 2651: bom_operational_routings or1,

2647: os1.routing_sequence_id,
2648: l_batch_id
2649: from
2650: bom_operation_sequences os1,
2651: bom_operational_routings or1,
2652: mtl_system_items si2,
2653: bom_inventory_components ic1,
2654: bom_bill_of_materials b1,
2655: mtl_system_items si1

Line 2978: bom_operational_routings or1,

2974: os1.routing_sequence_id
2975: from
2976: mtl_system_items si1,
2977: bom_cto_order_lines_upg bcol,
2978: bom_operational_routings or1,
2979: bom_operation_sequences os1
2980: where bcol.parent_ato_line_id = pLineId
2981: and si1.organization_id = pOrgId
2982: and si1.inventory_item_id = bcol.inventory_item_id

Line 3010: bom_operational_routings or1,

3006: bom_cto_order_lines_upg bcol1, /* components */
3007: bom_cto_order_lines_upg bcol2, /* parents model */
3008: bom_inventory_components ic1,
3009: bom_bill_of_materials b1,
3010: bom_operational_routings or1,
3011: bom_operation_sequences os1
3012: where bcol1.parent_ato_line_id = pLineId
3013: and bcol1.item_type_code in ('CLASS','OPTION')
3014: and bcol2.parent_ato_line_id = pLineId

Line 3068: bom_operational_routings or1,

3064: nvl(os1.operation_type,1),
3065: os1.routing_sequence_id
3066: from
3067: bom_operation_sequences os1,
3068: bom_operational_routings or1,
3069: mtl_system_items si2,
3070: bom_inventory_components ic1,
3071: bom_bill_of_materials b1,
3072: mtl_system_items si1,

Line 3426: xTableName := 'BOM_OPERATIONAL_ROUTINGS';

3422: there is no operation associated with the routing
3423: +-----------------------------------------------------------*/
3424:
3425: lStmtNum := 120;
3426: xTableName := 'BOM_OPERATIONAL_ROUTINGS';
3427:
3428: delete from BOM_OPERATIONAL_ROUTINGS b1
3429: where b1.routing_sequence_id not in
3430: (select routing_sequence_id

Line 3428: delete from BOM_OPERATIONAL_ROUTINGS b1

3424:
3425: lStmtNum := 120;
3426: xTableName := 'BOM_OPERATIONAL_ROUTINGS';
3427:
3428: delete from BOM_OPERATIONAL_ROUTINGS b1
3429: where b1.routing_sequence_id not in
3430: (select routing_sequence_id
3431: from bom_operation_sequences )
3432: and b1.routing_sequence_id = lCfgRtgId;

Line 3455: bom_operational_routings bor

3451: where not exists
3452: (select 'op seq exists in config routing'
3453: from
3454: bom_operation_sequences bos,
3455: bom_operational_routings bor
3456: where bos.operation_seq_num = ci.operation_seq_num
3457: and bos.routing_sequence_id = bor.routing_sequence_id
3458: and bor.assembly_item_id = pConfigId
3459: and bor.organization_id = pOrgId

Line 3476: X_from_entity_name =>'BOM_OPERATIONAL_ROUTINGS',

3472: oe_debug_pub.add ('create_routing_ml: Model routing_sequence_id:' || lItmRtgId, 2);
3473: END IF;
3474:
3475: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
3476: X_from_entity_name =>'BOM_OPERATIONAL_ROUTINGS',
3477: X_from_pk1_value =>lItmRtgId,
3478: X_from_pk2_value =>'',
3479: X_from_pk3_value =>'',
3480: X_from_pk4_value =>'',

Line 3482: X_to_entity_name =>'BOM_OPERATIONAL_ROUTINGS',

3478: X_from_pk2_value =>'',
3479: X_from_pk3_value =>'',
3480: X_from_pk4_value =>'',
3481: X_from_pk5_value =>'',
3482: X_to_entity_name =>'BOM_OPERATIONAL_ROUTINGS',
3483: X_to_pk1_value =>lCfgRtgId,
3484: X_to_pk2_value =>'',
3485: X_to_pk3_value =>'',
3486: X_to_pk4_value =>'',

Line 3529: from bom_operational_routings

3525:
3526: lstmtNum := 410;
3527: select nvl(cfm_routing_flag,2)
3528: into lCfmRtgFlag
3529: from bom_operational_routings
3530: where routing_sequence_id = lCfgrtgId;
3531:
3532:
3533: --

Line 3610: from bom_operational_routings

3606: --will select serial start op of model, only if effective on the day
3607: --as routing generation takes care of eefectivity, we check if op seq is present in config routing
3608: select serialization_start_op
3609: into l_ser_start_op
3610: from bom_operational_routings
3611: where assembly_item_id = pModelId
3612: and alternate_routing_designator is null
3613: and organization_id = pOrgId
3614: and serialization_start_op in

Line 3632: update bom_operational_routings

3628: lstmtNum := 413;
3629: WriteToLog('Before updating config routing with serial start op of option class', 4);
3630:
3631: begin
3632: update bom_operational_routings
3633: set serialization_start_op =
3634: ( select min( serialization_start_op)
3635: from bom_operational_routings
3636: where organization_id = pOrgId

Line 3635: from bom_operational_routings

3631: begin
3632: update bom_operational_routings
3633: set serialization_start_op =
3634: ( select min( serialization_start_op)
3635: from bom_operational_routings
3636: where organization_id = pOrgId
3637: and alternate_routing_designator is null
3638: and assembly_item_id in
3639: ( select component_item_id

Line 3665: update bom_operational_routings

3661:
3662: else --model has serial start op seq
3663:
3664: lstmtNum := 414;
3665: update bom_operational_routings
3666: set serialization_start_op = l_ser_start_op
3667: where routing_sequence_id = lCfgRtgId ;
3668:
3669: WriteToLog('Updated with serial start op of model, serial start op =>'||l_ser_start_op , 4);

Line 5407: from bom_operational_routings bor,

5403: NULL, /* ATTRIBUTE12 */
5404: NULL, /* ATTRIBUTE13 */
5405: NULL, /* ATTRIBUTE14 */
5406: NULL /* ATTRIBUTE15 */
5407: from bom_operational_routings bor,
5408: mtl_parameters mp,
5409: bom_cto_order_lines_upg bcolu
5410: where bcolu.sequence = p_seq
5411: and bcolu.status = 'BOM_LOOP'

Line 5522: bom_operational_routings bor1

5518: from
5519: bom_operation_sequences osi,
5520: bom_operation_resources bor,
5521: bom_cto_order_lines_upg bcolu,
5522: bom_operational_routings bor1
5523: where bcolu.sequence = p_seq
5524: and bcolu.status = 'BOM_LOOP'
5525: and bcolu.config_item_id = bor1.assembly_item_id
5526: and osi.routing_sequence_id = bor1.routing_sequence_id

Line 5640: bom_operational_routings bor

5636: from
5637: bom_operation_sequences osi,
5638: bom_sub_operation_resources bsor,
5639: bom_cto_order_lines_upg bcolu,
5640: bom_operational_routings bor
5641: where bcolu.sequence = p_seq
5642: and bcolu.status = 'BOM_LOOP'
5643: and bcolu.config_item_id = bor.assembly_item_id
5644: and osi.routing_sequence_id = bor.routing_sequence_id

Line 5727: bom_operational_routings brif,

5723: bom_operation_sequences bos1, /* 'from' Ops of model */
5724: bom_operation_sequences bos2, /* 'to' Ops of model */
5725: bom_operation_sequences bos3, /* 'from' Ops of config */
5726: bom_operation_sequences bos4, /* 'to' Ops of config */
5727: bom_operational_routings brif,
5728: bom_cto_order_lines_upg bcolu
5729: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
5730: AND bon.to_op_seq_id = bos2.operation_sequence_id
5731: AND bos1.routing_sequence_id = bos2.routing_sequence_id

Line 5746: from bom_operational_routings bor,

5742: AND bos4.operation_seq_num = bos2.operation_seq_num
5743: AND NVL(bos4.operation_type,1) = NVL(bos2.operation_type, 1)
5744: AND bos1.routing_sequence_id = ( /* find the model routing */
5745: select routing_sequence_id
5746: from bom_operational_routings bor,
5747: mtl_system_items msi
5748: where brif.assembly_item_id = msi.inventory_item_id
5749: and brif.organization_id = msi.organization_id
5750: and bor.assembly_item_id = msi.base_item_id

Line 7108: from bom_operational_routings

7104: select routing_sequence_id,
7105: NVL(cfm_routing_flag,2)
7106: into xRtgId,
7107: xRtgType
7108: from bom_operational_routings
7109: where assembly_item_id = pItemId
7110: and organization_id = pOrgId
7111: and alternate_routing_designator is null;
7112: