APPS.BOM_ROUTINGHEADER_PVT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 33: From bom_operational_routings

29: cursor l_OldAssy_csr(P_RtgSeqId number) is
30: Select assembly_item_id,
31: organization_id,
32: alternate_routing_designator
33: From bom_operational_routings
34: Where routing_sequence_id = P_RtgSeqId;
35:
36: cursor l_OldRtg_csr(P_AssyId number, P_OrgId number,
37: P_Alternate varchar2) is

Line 39: From bom_operational_routings bor

35:
36: cursor l_OldRtg_csr(P_AssyId number, P_OrgId number,
37: P_Alternate varchar2) is
38: Select bor.routing_sequence_id
39: From bom_operational_routings bor
40: Where bor.assembly_item_id = P_AssyId
41: And bor.organization_id = P_OrgId
42: And nvl(bor.alternate_routing_designator, 'PRIMARY ALT') =
43: nvl(P_Alternate , 'PRIMARY ALT');

Line 59: From bom_operational_routings

55: P_Alt varchar2) is
56: Select routing_sequence_id,
57: completion_subinventory,
58: completion_locator_id
59: From bom_operational_routings
60: Where assembly_item_id = P_AssyId
61: And organization_id = P_OrgId
62: And nvl(alternate_routing_designator, 'primary alternate') =
63: nvl(P_Alt, 'primary alternate');

Line 69: From bom_operational_routings

65: P_Alternate varchar2) is
66: Select assembly_item_id,
67: completion_subinventory,
68: completion_locator_id
69: From bom_operational_routings
70: Where routing_sequence_id = P_SeqId
71: And organization_id = P_OrgId
72: And nvl(alternate_routing_designator, 'Primary Alternate') =
73: nvl(P_Alternate, 'Primary Alternate');

Line 350: from bom_operational_routings

346: Select 1 dummy
347: From dual
348: Where exists (
349: select null
350: from bom_operational_routings
351: where routing_sequence_id <> P_RtgSeqId
352: and assembly_item_id = P_AssyId
353: and organization_id = P_OrgId
354: and nvl(alternate_routing_designator, 'Primary Alternate')

Line 362: from bom_operational_routings

358: Select 1 dummy
359: From dual
360: Where not exists (
361: select null
362: from bom_operational_routings
363: where organization_id = P_OrgId
364: and assembly_item_id = P_AssyId
365: and alternate_routing_designator is null
366: and ( routing_type = P_RtgType OR routing_type = 1));

Line 388: from bom_operational_routings

384: Select 1 dummy
385: From dual
386: Where not exists (
387: select null
388: from bom_operational_routings
389: where routing_sequence_id = P_RtgSeqId);
390:
391: -- Common routing's alt must be same as current routing's alt
392: -- Common routing cannot have same assembly_item_id as current routing

Line 406: from bom_operational_routings bor

402: Select 1 dummy
403: From dual
404: Where not exists (
405: select null
406: from bom_operational_routings bor
407: where bor.routing_sequence_id = P_cmn_rtg_id
408: and nvl(bor.alternate_routing_designator,
409: 'Primary Alternate') = nvl(P_alt_desg, 'Primary Alternate')
410: and bor.common_routing_sequence_id =

Line 498: From bom_operational_routings bor

494: Select 'x' dummy
495: From dual
496: Where exists (
497: Select null
498: From bom_operational_routings bor
499: Where bor.assembly_item_id = p_item_id
500: And bor.organization_id = p_org_id
501: And nvl(bor.alternate_routing_designator,
502: 'Primary Alternate') <>

Line 512: From bom_operational_routings bor

508: Select 'x' dummy
509: From dual
510: Where exists (
511: Select null
512: From bom_operational_routings bor
513: Where bor.assembly_item_id = p_item_id
514: And bor.organization_id = p_org_id
515: And nvl(bor.alternate_routing_designator,
516: 'Primary Alternate') <>

Line 525: From bom_operational_routings bor

521: Select 'x' dummy
522: From dual
523: Where exists (
524: Select null
525: From bom_operational_routings bor
526: Where bor.assembly_item_id = p_item_id
527: And bor.organization_id = p_org_id
528: And nvl(bor.alternate_routing_designator,
529: 'Primary Alternate') <>

Line 534: From bom_operational_routings bor

530: nvl(p_alternate, 'Primary Alternate')
531: And bor.ctp_flag = g_yes);
532: cursor l_OldLine_csr (P_RtgSeqId number) is
533: Select bor.line_id
534: From bom_operational_routings bor
535: Where bor.routing_sequence_id = P_RtgSeqId
536: And exists (
537: Select null
538: From bom_operation_sequences bos

Line 997: bom_operational_routings_s.nextval routing_sequence_id

993: l_api_version CONSTANT NUMBER := 1;
994: l_routing_rec ROUTING_REC_TYPE;
995: cursor l_NewRtg_csr is
996: Select
997: bom_operational_routings_s.nextval routing_sequence_id
998: From dual;
999: l_UserId number;
1000: l_LoginId number;
1001: l_RequestId number;

Line 1182: Insert into bom_operational_routings(

1178: Else
1179: l_ProgramUpdate := sysdate;
1180: End if;
1181:
1182: Insert into bom_operational_routings(
1183: routing_sequence_id,
1184: assembly_item_id,
1185: organization_id,
1186: alternate_routing_designator,

Line 1373: From bom_operational_routings bor

1369: cursor l_ExistingRouting(p_routing_seq_id number,
1370: p_assy_item_id number, p_org_id number,
1371: p_alternate varchar2)is
1372: Select *
1373: From bom_operational_routings bor
1374: Where bor.routing_sequence_id = p_routing_seq_id
1375: Or (bor.assembly_item_id = p_assy_item_id and
1376: bor.organization_id = p_org_id and
1377: nvl(bor.alternate_routing_designator,

Line 1576: update bom_operational_routings set

1572: l_ProgramUpdate := null;
1573: Else
1574: l_ProgramUpdate := sysdate;
1575: End if;
1576: update bom_operational_routings set
1577: last_update_date = sysdate,
1578: last_updated_by = l_UserId,
1579: -- creation_date = nvl(creation_date,sysdate), /* Commented for Bug 3271195 */
1580: -- created_by = l_UserId, /* Commented for Bug 3271195 */

Line 1683: From bom_operational_routings bor

1679: bor.assembly_item_id,
1680: bor.organization_id,
1681: bor.alternate_routing_designator,
1682: bor.routing_type
1683: From bom_operational_routings bor
1684: Where bor.routing_sequence_id = p_routing_seq_id
1685: Or (bor.assembly_item_id = p_assy_item_id and
1686: bor.organization_id = p_org_id and
1687: nvl(bor.alternate_routing_designator,