APPS.BOM_RTG_OI_UTIL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 74: FROM BOM_OPERATIONAL_ROUTINGS BOR1

70:
71: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
72: SET(assembly_item_id, organization_id, alternate_routing_designator)
73: = (SELECT assembly_item_id, organization_id , alternate_routing_designator
74: FROM BOM_OPERATIONAL_ROUTINGS BOR1
75: WHERE BOR1.routing_sequence_id = BORI.routing_sequence_id)
76: WHERE process_flag = 1
77: AND upper(transaction_type) in (G_Delete, G_Update)
78: AND routing_sequence_id is not null

Line 85: FROM BOM_OPERATIONAL_ROUTINGS BOR2

81: ( (p_batch_id IS NULL) AND (BORI.batch_id IS NULL) )
82: OR ( p_batch_id = BORI.batch_id )
83: )
84: AND exists (SELECT 'x'
85: FROM BOM_OPERATIONAL_ROUTINGS BOR2
86: WHERE BOR2.routing_sequence_id = BORI.routing_sequence_id);
87:
88: stmt_num := 2;
89:

Line 191: FROM BOM_OPERATIONAL_ROUTINGS BOR1

187:
188: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
189: SET(common_assembly_item_id)
190: = (SELECT assembly_item_id
191: FROM BOM_OPERATIONAL_ROUTINGS BOR1
192: WHERE BOR1.routing_sequence_id = BORI.common_routing_sequence_id)
193: WHERE process_flag = 1
194: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
195: AND common_routing_sequence_id is not null

Line 202: FROM BOM_OPERATIONAL_ROUTINGS BOR2

198: ( (p_batch_id IS NULL) AND (BORI.batch_id IS NULL) )
199: OR ( p_batch_id = BORI.batch_id )
200: )
201: AND exists (SELECT 'x'
202: FROM BOM_OPERATIONAL_ROUTINGS BOR2
203: WHERE BOR2.routing_sequence_id = BORI.common_routing_sequence_id);
204:
205: stmt_num :=7;
206:

Line 501: FROM BOM_OPERATIONAL_ROUTINGS BOR1

497:
498: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
499: SET(assembly_item_id, organization_id, alternate_routing_designator)
500: = (SELECT assembly_item_id, organization_id , alternate_routing_designator
501: FROM BOM_OPERATIONAL_ROUTINGS BOR1
502: WHERE BOR1.routing_sequence_id = BOSI.routing_sequence_id)
503: WHERE process_flag = 1
504: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
505: AND routing_sequence_id is not null

Line 512: FROM BOM_OPERATIONAL_ROUTINGS BOR2

508: ( (p_batch_id IS NULL) AND (BOSI.batch_id IS NULL) )
509: OR ( p_batch_id = BOSI.batch_id )
510: )
511: AND exists (SELECT 'x'
512: FROM BOM_OPERATIONAL_ROUTINGS BOR2
513: WHERE BOR2.routing_sequence_id = BOSI.routing_sequence_id);
514:
515:
516: stmt_num := 3;

Line 1062: FROM BOM_OPERATIONAL_ROUTINGS BOR1

1058:
1059: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1060: SET(assembly_item_id, organization_id, alternate_routing_designator)
1061: = (SELECT assembly_item_id, organization_id, alternate_routing_designator
1062: FROM BOM_OPERATIONAL_ROUTINGS BOR1
1063: WHERE BOR1.routing_sequence_id = BORI.routing_sequence_id)
1064: WHERE process_flag = 1
1065: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1066: AND routing_sequence_id is not null

Line 1073: FROM BOM_OPERATIONAL_ROUTINGS BOR2

1069: ( (p_batch_id IS NULL) AND (BORI.batch_id IS NULL) )
1070: OR ( p_batch_id = BORI.batch_id )
1071: )
1072: AND exists (SELECT 'x'
1073: FROM BOM_OPERATIONAL_ROUTINGS BOR2
1074: WHERE BOR2.routing_sequence_id = BORI.routing_sequence_id);
1075:
1076:
1077: stmt_num := 3;

Line 1339: FROM BOM_OPERATIONAL_ROUTINGS BOR1

1335:
1336: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1337: SET(assembly_item_id, organization_id, alternate_routing_designator)
1338: = (SELECT assembly_item_id, organization_id , alternate_routing_designator
1339: FROM BOM_OPERATIONAL_ROUTINGS BOR1
1340: WHERE BOR1.routing_sequence_id = BSORI.routing_sequence_id)
1341: WHERE process_flag = 1
1342: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1343: AND routing_sequence_id is not null

Line 1350: FROM BOM_OPERATIONAL_ROUTINGS BOR2

1346: ( (p_batch_id IS NULL) AND (BSORI.batch_id IS NULL) )
1347: OR ( p_batch_id = BSORI.batch_id )
1348: )
1349: AND exists (SELECT 'x'
1350: FROM BOM_OPERATIONAL_ROUTINGS BOR2
1351: WHERE BOR2.routing_sequence_id = BSORI.routing_sequence_id);
1352:
1353:
1354: stmt_num := 3;

Line 1633: FROM BOM_OPERATIONAL_ROUTINGS BOR1

1629:
1630: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1631: SET(assembly_item_id, organization_id, alternate_routing_designator)
1632: = (SELECT assembly_item_id, organization_id , alternate_routing_designator
1633: FROM BOM_OPERATIONAL_ROUTINGS BOR1
1634: WHERE BOR1.routing_sequence_id = BONI.routing_sequence_id)
1635: WHERE process_flag = 1
1636: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1637: AND routing_sequence_id is not null

Line 1644: FROM BOM_OPERATIONAL_ROUTINGS BOR2

1640: ( (p_batch_id IS NULL) AND (BONI.batch_id IS NULL) )
1641: OR ( p_batch_id = BONI.batch_id )
1642: )
1643: AND exists (SELECT 'x'
1644: FROM BOM_OPERATIONAL_ROUTINGS BOR2
1645: WHERE BOR2.routing_sequence_id = BONI.routing_sequence_id);
1646:
1647:
1648: stmt_num := 3;