APPS.ENG_VAL_TO_ID dependencies on ENG_REVISED_ITEMS

Line 1493: FROM eng_revised_items

1489: RETURN NUMBER IS
1490: l_dummy VARCHAR2(80);
1491: CURSOR c_BillExists IS
1492: SELECT 'Valid' b_valid
1493: FROM eng_revised_items
1494: WHERE revised_item_sequence_id = p_revised_item_seq_id
1495: AND bill_sequence_id IS NOT NULL;
1496: BEGIN
1497: -- Derive Bill_Sequence_id and assembly_item_id from Revised_item_sequence_id

Line 1508: FROM eng_revised_items

1504: SELECT bill_sequence_id,
1505: revised_item_id
1506: INTO x_bill_sequence_id,
1507: x_assembly_item_id
1508: FROM eng_revised_items
1509: WHERE revised_item_sequence_id = p_revised_item_seq_id;
1510: ****************************************/
1511:
1512: RETURN 1; --indicating success of the conversion

Line 1539: FROM eng_revised_items

1535: l_Rev_Item_Seq NUMBER;
1536: BEGIN
1537: SELECT bill_sequence_id, revised_item_Sequence_id
1538: INTO l_Bill_Seq, l_Rev_Item_Seq
1539: FROM eng_revised_items
1540: WHERE revised_item_id = p_revised_item_id
1541: AND NVL(new_item_revision,'NULL')= NVL(p_item_revision,'NULL')
1542: AND TRUNC(scheduled_date) = trunc(p_effective_date)
1543: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)

Line 1569: FROM eng_revised_items

1565: BEGIN
1566: /*********************************************************
1567: SELECT revised_item_id
1568: INTO l_assembly_item_id
1569: FROM eng_revised_items
1570: WHERE revised_item_sequence_id = p_revised_item_seq_id;
1571:
1572: RETURN l_assembly_item_id;
1573:

Line 1593: FROM Eng_revised_items

1589: BEGIN
1590:
1591: SELECT revised_item_sequence_id
1592: INTO l_id
1593: FROM Eng_revised_items
1594: WHERE revised_item_id = p_revised_item_id
1595: AND change_notice = p_change_notice
1596: AND organization_id = p_organization_id
1597: AND NVL(new_item_revision, 'NONE') =

Line 1652: cursor parent (rev_item_id eng_revised_items.revised_item_id%TYPE

1648: ,p_schedule_date DATE
1649: ,p_change_id NUMBER
1650: ) RETURN NUMBER
1651: IS
1652: cursor parent (rev_item_id eng_revised_items.revised_item_id%TYPE
1653: ) is
1654: select revised_item_sequence_id
1655: from eng_revised_items
1656: where REVISED_ITEM_ID = rev_item_id and

Line 1655: from eng_revised_items

1651: IS
1652: cursor parent (rev_item_id eng_revised_items.revised_item_id%TYPE
1653: ) is
1654: select revised_item_sequence_id
1655: from eng_revised_items
1656: where REVISED_ITEM_ID = rev_item_id and
1657: organization_id = p_organization_id and
1658: nvl(alternate_bom_designator,'NULL') = nvl(p_alternate_bom_code,'NULL')and
1659: SCHEDULED_DATE = p_schedule_date and

Line 3270: cursor c1 (rev_item_id eng_revised_items.revised_item_id%TYPE,

3266: l_Bill_Seq NUMBER;
3267: l_Rev_Item_Seq NUMBER;
3268: l_Bill_Seq1 NUMBER := NULL; -- Bug 2429272 Change2 Begin
3269:
3270: cursor c1 (rev_item_id eng_revised_items.revised_item_id%TYPE,
3271: org_id eng_revised_items.organization_id%TYPE,
3272: alt_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE) is
3273: select bill_sequence_id
3274: from bom_bill_of_materials

Line 3271: org_id eng_revised_items.organization_id%TYPE,

3267: l_Rev_Item_Seq NUMBER;
3268: l_Bill_Seq1 NUMBER := NULL; -- Bug 2429272 Change2 Begin
3269:
3270: cursor c1 (rev_item_id eng_revised_items.revised_item_id%TYPE,
3271: org_id eng_revised_items.organization_id%TYPE,
3272: alt_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE) is
3273: select bill_sequence_id
3274: from bom_bill_of_materials
3275: where assembly_item_id = rev_item_id and

Line 3286: organization and change_notice) exists for this eco in eng_revised_items

3282: primary bill and alternate bill. But the calling procedure/function
3283: is calling this procedure only with revised_item_id , organization_id
3284: and change_notice but not using the parameter alternate_bom_designator.
3285: But there are two records(primary and alt with same revised_item_id,
3286: organization and change_notice) exists for this eco in eng_revised_items
3287: . So, querying eng_revised_items only with revised_item_id, org_id and
3288: change_notice will retrieve two records which is causing the error
3289: */
3290:

Line 3287: . So, querying eng_revised_items only with revised_item_id, org_id and

3283: is calling this procedure only with revised_item_id , organization_id
3284: and change_notice but not using the parameter alternate_bom_designator.
3285: But there are two records(primary and alt with same revised_item_id,
3286: organization and change_notice) exists for this eco in eng_revised_items
3287: . So, querying eng_revised_items only with revised_item_id, org_id and
3288: change_notice will retrieve two records which is causing the error
3289: */
3290:
3291: BEGIN

Line 3316: FROM eng_revised_items

3312: , x_to_wip_entity_id
3313: , x_from_cum_qty
3314: , x_eco_for_production
3315: , x_cfm_routing_flag
3316: FROM eng_revised_items
3317: WHERE NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR )
3318: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR)
3319: AND NVL(new_routing_revision,FND_API.G_MISS_CHAR)
3320: = NVL(p_new_routing_revision,FND_API.G_MISS_CHAR)

Line 3345: FROM eng_revised_items

3341: , x_to_wip_entity_id
3342: , x_from_cum_qty
3343: , x_eco_for_production
3344: , x_cfm_routing_flag
3345: FROM eng_revised_items
3346: WHERE NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR )
3347: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR)
3348: AND NVL(new_routing_revision,FND_API.G_MISS_CHAR)
3349: = NVL(p_new_routing_revision,FND_API.G_MISS_CHAR)

Line 3422: FROM eng_revised_items

3418: , x_to_wip_entity_id
3419: , x_from_cum_qty
3420: , x_eco_for_production
3421: , x_cfm_routing_flag
3422: FROM eng_revised_items
3423: WHERE NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR )
3424: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR)
3425: AND NVL(new_routing_revision, FND_API.G_MISS_CHAR) =
3426: NVL(p_new_routing_revision, FND_API.G_MISS_CHAR)