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 499: FROM BOM_OPERATIONAL_ROUTINGS BOR1

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

Line 510: FROM BOM_OPERATIONAL_ROUTINGS BOR2

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

Line 1060: FROM BOM_OPERATIONAL_ROUTINGS BOR1

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

Line 1071: FROM BOM_OPERATIONAL_ROUTINGS BOR2

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

Line 1337: FROM BOM_OPERATIONAL_ROUTINGS BOR1

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

Line 1348: FROM BOM_OPERATIONAL_ROUTINGS BOR2

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

Line 1631: FROM BOM_OPERATIONAL_ROUTINGS BOR1

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

Line 1642: FROM BOM_OPERATIONAL_ROUTINGS BOR2

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