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

525: /*---------------------------------------------------------------+
526: Get new routing_id and the type of routing to be created.
527: +----------------------------------------------------------------*/
528:
529: select bom_operational_routings_s.nextval
530: into lCfgRtgId
531: from dual;
532:
533: /*---------------------------------------------------------------+

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

537: xTableName := 'BOM_OPERATIONAL_ROUTING';
538: lStmtNum := 30;
539:
540: IF PG_DEBUG <> 0 THEN
541: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting the routing header information into bom_operational_routings..',5);
542: END IF;
543:
544: insert into bom_operational_routings
545: (

Line 544: insert into bom_operational_routings

540: IF PG_DEBUG <> 0 THEN
541: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting the routing header information into bom_operational_routings..',5);
542: END IF;
543:
544: insert into bom_operational_routings
545: (
546: routing_sequence_id,
547: assembly_item_id,
548: organization_id,

Line 635: bom_operational_routings bor,

631: bor.ctp_flag,
632: bor.project_id,
633: bor.task_id
634: from
635: bom_operational_routings bor,
636: mtl_parameters mp
637: where bor.assembly_item_id = pModelId
638: and bor.organization_id = pOrgId
639: and bor.alternate_routing_designator is null

Line 655: update bom_operational_routings b

651: +----------------------------------------------------------------*/
652:
653: lStmtNum := 40;
654:
655: update bom_operational_routings b
656: set mixed_model_map_flag =
657: ( select 1
658: from bom_operational_routings bor
659: where bor.assembly_item_id = pModelId

Line 658: from bom_operational_routings bor

654:
655: update bom_operational_routings b
656: set mixed_model_map_flag =
657: ( select 1
658: from bom_operational_routings bor
659: where bor.assembly_item_id = pModelId
660: and bor.organization_id = pOrgId
661: and bor.cfm_routing_flag = 1
662: and bor.mixed_model_map_flag = 1

Line 824: bom_operational_routings or1,

820: x_coordinate,
821: y_coordinate
822: FROM bom_cto_order_lines bcol1,
823: mtl_system_items si1,
824: bom_operational_routings or1,
825: bom_operation_sequences os1
826: WHERE bcol1.line_id = pLineId
827: AND bcol1.inventory_item_id = pModelId
828: AND si1.organization_id = pOrgId -- this is the mfg org from src_orgs

Line 982: bom_operational_routings or1,

978: bom_cto_order_lines bcol2, -- parent models or option classes
979: mtl_system_items msi,
980: bom_inventory_components ic1,
981: bom_bill_of_materials b1,
982: bom_operational_routings or1,
983: bom_operation_sequences os1
984: WHERE bcol1.parent_ato_line_id = pLineId /*AP*/
985: AND bcol1.item_type_code in ('CLASS','OPTION')
986: AND bcol1.line_id <> bcol2.line_id

Line 1191: bom_operational_routings or1,

1187: x_coordinate,
1188: y_coordinate
1189: -- 5336292
1190: FROM bom_operation_sequences os1,
1191: bom_operational_routings or1,
1192: mtl_system_items si2,
1193: bom_inventory_components ic1,
1194: bom_bill_of_materials b1,
1195: mtl_system_items si1

Line 1662: bom_operational_routings or1,

1658: x_coordinate,
1659: y_coordinate
1660: FROM mtl_system_items si1,
1661: bom_cto_order_lines bcol,
1662: bom_operational_routings or1,
1663: bom_operation_sequences os1
1664: WHERE bcol.parent_ato_line_id = pLineId
1665: AND si1.organization_id = pOrgId
1666: AND si1.inventory_item_id = bcol.inventory_item_id

Line 1829: bom_operational_routings or1,

1825: FROM bom_cto_order_lines bcol1, /* components */
1826: bom_cto_order_lines bcol2, /* parents model */
1827: bom_inventory_components ic1,
1828: bom_bill_of_materials b1,
1829: bom_operational_routings or1,
1830: bom_operation_sequences os1
1831: WHERE bcol1.parent_ato_line_id = pLineId
1832: AND bcol1.item_type_code in ('CLASS','OPTION')
1833: AND bcol2.parent_ato_line_id = pLineId

Line 2035: bom_operational_routings or1,

2031: x_coordinate,
2032: y_coordinate
2033:
2034: FROM bom_operation_sequences os1,
2035: bom_operational_routings or1,
2036: mtl_system_items si2,
2037: bom_inventory_components ic1,
2038: bom_bill_of_materials b1,
2039: mtl_system_items si1,

Line 2430: xTableName := 'BOM_OPERATIONAL_ROUTINGS';

2426: there is no operation associated with the routing
2427: +-----------------------------------------------------------*/
2428:
2429: lStmtNum := 120;
2430: xTableName := 'BOM_OPERATIONAL_ROUTINGS';
2431:
2432: delete from BOM_OPERATIONAL_ROUTINGS b1
2433: where b1.routing_sequence_id not in
2434: (select routing_sequence_id

Line 2432: delete from BOM_OPERATIONAL_ROUTINGS b1

2428:
2429: lStmtNum := 120;
2430: xTableName := 'BOM_OPERATIONAL_ROUTINGS';
2431:
2432: delete from BOM_OPERATIONAL_ROUTINGS b1
2433: where b1.routing_sequence_id not in
2434: (select routing_sequence_id
2435: from bom_operation_sequences )
2436: and b1.routing_sequence_id = lCfgRtgId;

Line 2461: bom_operational_routings bor

2457: where not exists
2458: (select 'op seq exists in config routing'
2459: from
2460: bom_operation_sequences bos,
2461: bom_operational_routings bor
2462: where bos.operation_seq_num = ci.operation_seq_num
2463: and bos.routing_sequence_id = bor.routing_sequence_id
2464: and bor.assembly_item_id = pConfigId
2465: and bor.organization_id = pOrgId

Line 2541: from bom_operational_routings bor,

2537: NULL, /* ATTRIBUTE12 */
2538: NULL, /* ATTRIBUTE13 */
2539: NULL, /* ATTRIBUTE14 */
2540: NULL /* ATTRIBUTE15 */
2541: from bom_operational_routings bor,
2542: mtl_parameters mp
2543: where bor.routing_sequence_id = lCfgRtgId
2544: and bor.organization_id = mp.organization_id;
2545:

Line 2832: bom_operational_routings brif

2828: bom_operation_sequences bos1, /* 'from' Ops of model */
2829: bom_operation_sequences bos2, /* 'to' Ops of model */
2830: bom_operation_sequences bos3, /* 'from' Ops of config */
2831: bom_operation_sequences bos4, /* 'to' Ops of config */
2832: bom_operational_routings brif
2833: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
2834: AND bon.to_op_seq_id = bos2.operation_sequence_id
2835: AND bos1.routing_sequence_id = bos2.routing_sequence_id
2836: AND bos3.routing_sequence_id = brif.routing_sequence_id

Line 2846: from bom_operational_routings bor,

2842: AND bos4.operation_seq_num = bos2.operation_seq_num
2843: AND NVL(bos4.operation_type,1) = NVL(bos2.operation_type, 1)
2844: AND bos1.routing_sequence_id = ( /* find the model routing */
2845: select common_routing_sequence_id --5103316
2846: from bom_operational_routings bor,
2847: mtl_system_items msi
2848: where brif.assembly_item_id = msi.inventory_item_id
2849: and brif.organization_id = msi.organization_id
2850: and bor.assembly_item_id = msi.base_item_id

Line 2879: X_from_entity_name =>'BOM_OPERATIONAL_ROUTINGS',

2875: oe_debug_pub.add ('create_routing_ml: Model routing_sequence_id:' || lItmRtgId, 2);
2876: END IF;
2877:
2878: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
2879: X_from_entity_name =>'BOM_OPERATIONAL_ROUTINGS',
2880: X_from_pk1_value =>lItmRtgId,
2881: X_from_pk2_value =>'',
2882: X_from_pk3_value =>'',
2883: X_from_pk4_value =>'',

Line 2885: X_to_entity_name =>'BOM_OPERATIONAL_ROUTINGS',

2881: X_from_pk2_value =>'',
2882: X_from_pk3_value =>'',
2883: X_from_pk4_value =>'',
2884: X_from_pk5_value =>'',
2885: X_to_entity_name =>'BOM_OPERATIONAL_ROUTINGS',
2886: X_to_pk1_value =>lCfgRtgId,
2887: X_to_pk2_value =>'',
2888: X_to_pk3_value =>'',
2889: X_to_pk4_value =>'',

Line 2932: from bom_operational_routings

2928:
2929: lstmtNum := 410;
2930: select nvl(cfm_routing_flag,2)
2931: into lCfmRtgFlag
2932: from bom_operational_routings
2933: where routing_sequence_id = lCfgrtgId;
2934:
2935:
2936: --

Line 3009: from bom_operational_routings

3005: --will select serial start op of model, only if effective on the day
3006: --as routing generation takes care of eefectivity, we check if op seq is present in config routing
3007: select serialization_start_op
3008: into l_ser_start_op
3009: from bom_operational_routings
3010: where assembly_item_id = pModelId
3011: and alternate_routing_designator is null
3012: and organization_id = pOrgId
3013: and serialization_start_op in

Line 3035: update bom_operational_routings

3031: oe_debug_pub.add('create_routing_ml: ' || 'before updating config routing with serial start op of option class', 4);
3032: END IF;
3033:
3034: begin
3035: update bom_operational_routings
3036: set serialization_start_op =
3037: ( select min( serialization_start_op)
3038: from bom_operational_routings
3039: where organization_id = pOrgId

Line 3038: from bom_operational_routings

3034: begin
3035: update bom_operational_routings
3036: set serialization_start_op =
3037: ( select min( serialization_start_op)
3038: from bom_operational_routings
3039: where organization_id = pOrgId
3040: and alternate_routing_designator is null
3041: and assembly_item_id in
3042: ( select component_item_id

Line 3074: update bom_operational_routings

3070:
3071: else --model has serial start op seq
3072:
3073: lstmtNum := 414;
3074: update bom_operational_routings
3075: set serialization_start_op = l_ser_start_op
3076: where routing_sequence_id = lCfgRtgId ;
3077:
3078: IF PG_DEBUG <> 0 THEN