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_CONFIG_ROUTING_PK dependencies on BOM_OPERATIONAL_ROUTINGS

Line 117: | into bom_operational_routings

113: | Renga Kannan 28-Jan-2004 Front Port bug fix 4049807
114: | Descriptive Flexfield Attribute
115: | category is not copied from model
116: | Added this column while inserting
117: | into bom_operational_routings
118: |
119: | Kiran Konada 05-Jan-2006 bugfix1765149
120: | get the x and Y coordinate on canvas for flow routing
121: *============================================================================*/

Line 156: from bom_operational_routings

152: select routing_sequence_id,
153: NVL(cfm_routing_flag,2)
154: into xRtgId,
155: xRtgType
156: from bom_operational_routings
157: where assembly_item_id = pItemId
158: and organization_id = pOrgId
159: and alternate_routing_designator is null;
160:

Line 540: select bom_operational_routings_s.nextval

536: /*---------------------------------------------------------------+
537: Get new routing_id and the type of routing to be created.
538: +----------------------------------------------------------------*/
539:
540: select bom_operational_routings_s.nextval
541: into lCfgRtgId
542: from dual;
543:
544:

Line 554: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting the routing header information into bom_operational_routings..',5);

550: lStmtNum := 30;
551:
552:
553: IF PG_DEBUG <> 0 THEN
554: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting the routing header information into bom_operational_routings..',5);
555: END IF;
556: insert into bom_operational_routings
557: (
558: routing_sequence_id,

Line 556: insert into bom_operational_routings

552:
553: IF PG_DEBUG <> 0 THEN
554: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting the routing header information into bom_operational_routings..',5);
555: END IF;
556: insert into bom_operational_routings
557: (
558: routing_sequence_id,
559: assembly_item_id,
560: organization_id,

Line 647: bom_operational_routings bor,

643: bor.ctp_flag,
644: bor.project_id,
645: bor.task_id
646: from
647: bom_operational_routings bor,
648: mtl_parameters mp
649: where bor.assembly_item_id = pModelId
650: and bor.organization_id = pOrgId
651: and bor.alternate_routing_designator is null

Line 667: update bom_operational_routings b

663: +----------------------------------------------------------------*/
664:
665: lStmtNum := 40;
666:
667: update bom_operational_routings b
668: set mixed_model_map_flag =
669: ( select 1
670: from bom_operational_routings bor
671: where bor.assembly_item_id = pModelId

Line 670: from bom_operational_routings bor

666:
667: update bom_operational_routings b
668: set mixed_model_map_flag =
669: ( select 1
670: from bom_operational_routings bor
671: where bor.assembly_item_id = pModelId
672: and bor.organization_id = pOrgId
673: and bor.cfm_routing_flag = 1
674: and bor.mixed_model_map_flag = 1

Line 840: bom_operational_routings or1,

836: x_coordinate,
837: y_coordinate
838: FROM bom_cto_order_lines bcol1,
839: mtl_system_items si1,
840: bom_operational_routings or1,
841: bom_operation_sequences os1
842: WHERE bcol1.line_id = pLineId
843: AND bcol1.inventory_item_id = pModelId
844: AND si1.organization_id = pOrgId -- this is the mfg org from src_orgs

Line 1001: bom_operational_routings or1,

997: bom_cto_order_lines bcol2, -- parent models or option classes
998: mtl_system_items msi,
999: bom_inventory_components ic1,
1000: bom_bill_of_materials b1,
1001: bom_operational_routings or1,
1002: bom_operation_sequences os1
1003: WHERE bcol1.parent_ato_line_id = pLineId /*AP*/
1004: AND bcol1.item_type_code in ('CLASS','OPTION')
1005: AND bcol1.line_id <> bcol2.line_id

Line 1209: bom_operational_routings or1,

1205: x_coordinate,
1206: y_coordinate
1207: -- 5336292
1208: FROM bom_operation_sequences os1,
1209: bom_operational_routings or1,
1210: mtl_system_items si2,
1211: bom_inventory_components ic1,
1212: bom_bill_of_materials b1,
1213: mtl_system_items si1

Line 1682: bom_operational_routings or1,

1678: x_coordinate,
1679: y_coordinate
1680: FROM mtl_system_items si1,
1681: bom_cto_order_lines bcol,
1682: bom_operational_routings or1,
1683: bom_operation_sequences os1
1684: WHERE bcol.parent_ato_line_id = pLineId
1685: AND si1.organization_id = pOrgId
1686: AND si1.inventory_item_id = bcol.inventory_item_id

Line 1848: bom_operational_routings or1,

1844: FROM bom_cto_order_lines bcol1, /* components */
1845: bom_cto_order_lines bcol2, /* parents model */
1846: bom_inventory_components ic1,
1847: bom_bill_of_materials b1,
1848: bom_operational_routings or1,
1849: bom_operation_sequences os1
1850: WHERE bcol1.parent_ato_line_id = pLineId
1851: AND bcol1.item_type_code in ('CLASS','OPTION')
1852: AND bcol2.parent_ato_line_id = pLineId

Line 2053: bom_operational_routings or1,

2049: x_coordinate,
2050: y_coordinate
2051:
2052: FROM bom_operation_sequences os1,
2053: bom_operational_routings or1,
2054: mtl_system_items si2,
2055: bom_inventory_components ic1,
2056: bom_bill_of_materials b1,
2057: mtl_system_items si1,

Line 2439: xTableName := 'BOM_OPERATIONAL_ROUTINGS';

2435: there is no operation associated with the routing
2436: +-----------------------------------------------------------*/
2437:
2438: lStmtNum := 120;
2439: xTableName := 'BOM_OPERATIONAL_ROUTINGS';
2440:
2441: delete from BOM_OPERATIONAL_ROUTINGS b1
2442: where b1.routing_sequence_id not in
2443: (select routing_sequence_id

Line 2441: delete from BOM_OPERATIONAL_ROUTINGS b1

2437:
2438: lStmtNum := 120;
2439: xTableName := 'BOM_OPERATIONAL_ROUTINGS';
2440:
2441: delete from BOM_OPERATIONAL_ROUTINGS b1
2442: where b1.routing_sequence_id not in
2443: (select routing_sequence_id
2444: from bom_operation_sequences )
2445: and b1.routing_sequence_id = lCfgRtgId;

Line 2470: bom_operational_routings bor

2466: where not exists
2467: (select 'op seq exists in config routing'
2468: from
2469: bom_operation_sequences bos,
2470: bom_operational_routings bor
2471: where bos.operation_seq_num = ci.operation_seq_num
2472: and bos.routing_sequence_id = bor.routing_sequence_id
2473: and bor.assembly_item_id = pConfigId
2474: and bor.organization_id = pOrgId

Line 2550: from bom_operational_routings bor,

2546: NULL, /* ATTRIBUTE12 */
2547: NULL, /* ATTRIBUTE13 */
2548: NULL, /* ATTRIBUTE14 */
2549: NULL /* ATTRIBUTE15 */
2550: from bom_operational_routings bor,
2551: mtl_parameters mp
2552: where bor.routing_sequence_id = lCfgRtgId
2553: and bor.organization_id = mp.organization_id;
2554:

Line 2840: bom_operational_routings brif

2836: bom_operation_sequences bos1, /* 'from' Ops of model */
2837: bom_operation_sequences bos2, /* 'to' Ops of model */
2838: bom_operation_sequences bos3, /* 'from' Ops of config */
2839: bom_operation_sequences bos4, /* 'to' Ops of config */
2840: bom_operational_routings brif
2841: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
2842: AND bon.to_op_seq_id = bos2.operation_sequence_id
2843: AND bos1.routing_sequence_id = bos2.routing_sequence_id
2844: AND bos3.routing_sequence_id = brif.routing_sequence_id

Line 2854: from bom_operational_routings bor,

2850: AND bos4.operation_seq_num = bos2.operation_seq_num
2851: AND NVL(bos4.operation_type,1) = NVL(bos2.operation_type, 1)
2852: AND bos1.routing_sequence_id = ( /* find the model routing */
2853: select common_routing_sequence_id --5103316
2854: from bom_operational_routings bor,
2855: mtl_system_items msi
2856: where brif.assembly_item_id = msi.inventory_item_id
2857: and brif.organization_id = msi.organization_id
2858: and bor.assembly_item_id = msi.base_item_id

Line 2912: from bom_operational_routings

2908:
2909: lstmtNum := 410;
2910: select nvl(cfm_routing_flag,2)
2911: into lCfmRtgFlag
2912: from bom_operational_routings
2913: where routing_sequence_id = lCfgrtgId;
2914:
2915:
2916: --

Line 2989: from bom_operational_routings

2985: --will select serial start op of model, only if effective on the day
2986: --as routing generation takes care of eefectivity, we check if op seq is present in config routing
2987: select serialization_start_op
2988: into l_ser_start_op
2989: from bom_operational_routings
2990: where assembly_item_id = pModelId
2991: and alternate_routing_designator is null
2992: and organization_id = pOrgId
2993: and serialization_start_op in

Line 3015: update bom_operational_routings

3011: oe_debug_pub.add('create_routing_ml: ' || 'before updating config routing with serial start op of option class', 4);
3012: END IF;
3013:
3014: begin
3015: update bom_operational_routings
3016: set serialization_start_op =
3017: ( select min( serialization_start_op)
3018: from bom_operational_routings
3019: where organization_id = pOrgId

Line 3018: from bom_operational_routings

3014: begin
3015: update bom_operational_routings
3016: set serialization_start_op =
3017: ( select min( serialization_start_op)
3018: from bom_operational_routings
3019: where organization_id = pOrgId
3020: and alternate_routing_designator is null
3021: and assembly_item_id in
3022: ( select component_item_id

Line 3054: update bom_operational_routings

3050:
3051: else --model has serial start op seq
3052:
3053: lstmtNum := 414;
3054: update bom_operational_routings
3055: set serialization_start_op = l_ser_start_op
3056: where routing_sequence_id = lCfgRtgId ;
3057:
3058: IF PG_DEBUG <> 0 THEN