APPS.BOM_REVISIONS dependencies on MTL_RTG_ITEM_REVISIONS

Line 604: FROM MTL_RTG_ITEM_REVISIONS MIR, ENG_REVISED_ITEMS ERI

600:
601: -- Added Cursor for BUG 3940863
602: CURSOR ECO_STATUS_RTG_REV IS
603: SELECT PROCESS_REVISION
604: FROM MTL_RTG_ITEM_REVISIONS MIR, ENG_REVISED_ITEMS ERI
605: WHERE MIR.INVENTORY_ITEM_ID = item_id
606: AND MIR.ORGANIZATION_ID = org_id
607: AND MIR.EFFECTIVITY_DATE <= rev_date --Bug 3020310
608: AND MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)

Line 627: FROM MTL_RTG_ITEM_REVISIONS

623:
624:
625: CURSOR RTG_REV IS
626: SELECT PROCESS_REVISION
627: FROM MTL_RTG_ITEM_REVISIONS
628: WHERE INVENTORY_ITEM_ID = item_id
629: AND ORGANIZATION_ID = org_id
630: -- AND trunc(EFFECTIVITY_DATE) <= trunc(rev_date) -- changed for bug 2631052
631: AND EFFECTIVITY_DATE <= rev_date

Line 814: FROM MTL_RTG_ITEM_REVISIONS

810: AND ORGANIZATION_ID = org_id;
811:
812: CURSOR RTG_REV IS
813: SELECT EFFECTIVITY_DATE
814: FROM MTL_RTG_ITEM_REVISIONS
815: WHERE INVENTORY_ITEM_ID = item_id
816: AND PROCESS_REVISION = itm_rev
817: AND ORGANIZATION_ID = org_id;
818:

Line 944: FROM MTL_RTG_ITEM_REVISIONS

940: ELSE
941: stmt_num := 3;
942: SELECT MIN(EFFECTIVITY_DATE - 1/(60*60*24))
943: INTO l_rev_date
944: FROM MTL_RTG_ITEM_REVISIONS
945: WHERE INVENTORY_ITEM_ID = item_id
946: AND ORGANIZATION_ID = org_id
947: AND EFFECTIVITY_DATE >
948: (SELECT EFFECTIVITY_DATE

Line 949: FROM MTL_RTG_ITEM_REVISIONS

945: WHERE INVENTORY_ITEM_ID = item_id
946: AND ORGANIZATION_ID = org_id
947: AND EFFECTIVITY_DATE >
948: (SELECT EFFECTIVITY_DATE
949: FROM MTL_RTG_ITEM_REVISIONS
950: WHERE INVENTORY_ITEM_ID = item_id
951: AND ORGANIZATION_ID = org_id
952: AND PROCESS_REVISION = itm_rev);
953: /*

Line 956: FROM MTL_RTG_ITEM_REVISIONS

952: AND PROCESS_REVISION = itm_rev);
953: /*
954: SELECT MIN(EFFECTIVITY_DATE - 60/(60*60*24)) -- changed for bug 2631052
955: INTO l_rev_date
956: FROM MTL_RTG_ITEM_REVISIONS
957: WHERE INVENTORY_ITEM_ID = item_id
958: AND ORGANIZATION_ID = org_id
959: AND trunc(EFFECTIVITY_DATE) >
960: (SELECT trunc(EFFECTIVITY_DATE)

Line 961: FROM MTL_RTG_ITEM_REVISIONS

957: WHERE INVENTORY_ITEM_ID = item_id
958: AND ORGANIZATION_ID = org_id
959: AND trunc(EFFECTIVITY_DATE) >
960: (SELECT trunc(EFFECTIVITY_DATE)
961: FROM MTL_RTG_ITEM_REVISIONS
962: WHERE INVENTORY_ITEM_ID = item_id
963: AND ORGANIZATION_ID = org_id
964: AND PROCESS_REVISION = itm_rev);
965: */

Line 986: FROM MTL_RTG_ITEM_REVISIONS

982: ELSE
983: stmt_num := 5;
984: SELECT GREATEST(EFFECTIVITY_DATE,SYSDATE)
985: INTO l_rev_date
986: FROM MTL_RTG_ITEM_REVISIONS
987: WHERE INVENTORY_ITEM_ID = item_id
988: AND ORGANIZATION_ID = org_id
989: AND PROCESS_REVISION = itm_rev;
990: END IF;

Line 1077: FROM MTL_RTG_ITEM_REVISIONS

1073: ORDER BY EFFECTIVITY_DATE DESC, REVISION DESC;
1074:
1075: CURSOR RTG_REV IS
1076: SELECT PROCESS_REVISION
1077: FROM MTL_RTG_ITEM_REVISIONS
1078: WHERE INVENTORY_ITEM_ID = item_id
1079: AND ORGANIZATION_ID = org_id
1080: AND (
1081: (examine_type = 'ALL')