APPS.ENG_VAL_TO_ID dependencies on ENG_REVISED_ITEMS

Line 1499: FROM eng_revised_items

1495: RETURN NUMBER IS
1496: l_dummy VARCHAR2(80);
1497: CURSOR c_BillExists IS
1498: SELECT 'Valid' b_valid
1499: FROM eng_revised_items
1500: WHERE revised_item_sequence_id = p_revised_item_seq_id
1501: AND bill_sequence_id IS NOT NULL;
1502: BEGIN
1503: -- Derive Bill_Sequence_id and assembly_item_id from Revised_item_sequence_id

Line 1514: FROM eng_revised_items

1510: SELECT bill_sequence_id,
1511: revised_item_id
1512: INTO x_bill_sequence_id,
1513: x_assembly_item_id
1514: FROM eng_revised_items
1515: WHERE revised_item_sequence_id = p_revised_item_seq_id;
1516: ****************************************/
1517:
1518: RETURN 1; --indicating success of the conversion

Line 1545: FROM eng_revised_items

1541: l_Rev_Item_Seq NUMBER;
1542: BEGIN
1543: SELECT bill_sequence_id, revised_item_Sequence_id
1544: INTO l_Bill_Seq, l_Rev_Item_Seq
1545: FROM eng_revised_items
1546: WHERE revised_item_id = p_revised_item_id
1547: AND NVL(new_item_revision,'NULL')= NVL(p_item_revision,'NULL')
1548: AND TRUNC(scheduled_date) = trunc(p_effective_date)
1549: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)

Line 1575: FROM eng_revised_items

1571: BEGIN
1572: /*********************************************************
1573: SELECT revised_item_id
1574: INTO l_assembly_item_id
1575: FROM eng_revised_items
1576: WHERE revised_item_sequence_id = p_revised_item_seq_id;
1577:
1578: RETURN l_assembly_item_id;
1579:

Line 1599: FROM Eng_revised_items

1595: BEGIN
1596:
1597: SELECT revised_item_sequence_id
1598: INTO l_id
1599: FROM Eng_revised_items
1600: WHERE revised_item_id = p_revised_item_id
1601: AND change_notice = p_change_notice
1602: AND organization_id = p_organization_id
1603: AND NVL(new_item_revision, 'NONE') =

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

1654: ,p_schedule_date DATE
1655: ,p_change_id NUMBER
1656: ) RETURN NUMBER
1657: IS
1658: cursor parent (rev_item_id eng_revised_items.revised_item_id%TYPE
1659: ) is
1660: select revised_item_sequence_id
1661: from eng_revised_items
1662: where REVISED_ITEM_ID = rev_item_id and

Line 1661: from eng_revised_items

1657: IS
1658: cursor parent (rev_item_id eng_revised_items.revised_item_id%TYPE
1659: ) is
1660: select revised_item_sequence_id
1661: from eng_revised_items
1662: where REVISED_ITEM_ID = rev_item_id and
1663: organization_id = p_organization_id and
1664: nvl(alternate_bom_designator,'NULL') = nvl(p_alternate_bom_code,'NULL')and
1665: SCHEDULED_DATE = p_schedule_date and

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

3272: l_Bill_Seq NUMBER;
3273: l_Rev_Item_Seq NUMBER;
3274: l_Bill_Seq1 NUMBER := NULL; -- Bug 2429272 Change2 Begin
3275:
3276: cursor c1 (rev_item_id eng_revised_items.revised_item_id%TYPE,
3277: org_id eng_revised_items.organization_id%TYPE,
3278: alt_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE) is
3279: select bill_sequence_id
3280: from bom_bill_of_materials

Line 3277: org_id eng_revised_items.organization_id%TYPE,

3273: l_Rev_Item_Seq NUMBER;
3274: l_Bill_Seq1 NUMBER := NULL; -- Bug 2429272 Change2 Begin
3275:
3276: cursor c1 (rev_item_id eng_revised_items.revised_item_id%TYPE,
3277: org_id eng_revised_items.organization_id%TYPE,
3278: alt_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE) is
3279: select bill_sequence_id
3280: from bom_bill_of_materials
3281: where assembly_item_id = rev_item_id and

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

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

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

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

Line 3322: FROM eng_revised_items

3318: , x_to_wip_entity_id
3319: , x_from_cum_qty
3320: , x_eco_for_production
3321: , x_cfm_routing_flag
3322: FROM eng_revised_items
3323: WHERE NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR )
3324: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR)
3325: AND NVL(new_routing_revision,FND_API.G_MISS_CHAR)
3326: = NVL(p_new_routing_revision,FND_API.G_MISS_CHAR)

Line 3351: FROM eng_revised_items

3347: , x_to_wip_entity_id
3348: , x_from_cum_qty
3349: , x_eco_for_production
3350: , x_cfm_routing_flag
3351: FROM eng_revised_items
3352: WHERE NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR )
3353: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR)
3354: AND NVL(new_routing_revision,FND_API.G_MISS_CHAR)
3355: = NVL(p_new_routing_revision,FND_API.G_MISS_CHAR)

Line 3429: FROM eng_revised_items

3425: , x_to_wip_entity_id
3426: , x_from_cum_qty
3427: , x_eco_for_production
3428: , x_cfm_routing_flag
3429: FROM eng_revised_items
3430: WHERE NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR )
3431: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR)
3432: AND NVL(new_routing_revision, FND_API.G_MISS_CHAR) =
3433: NVL(p_new_routing_revision, FND_API.G_MISS_CHAR)