APPS.BOM_REVISIONS dependencies on MTL_RTG_ITEM_REVISIONS

Line 595: FROM MTL_RTG_ITEM_REVISIONS MIR, ENG_REVISED_ITEMS ERI

591:
592: -- Added Cursor for BUG 3940863
593: CURSOR ECO_STATUS_RTG_REV IS
594: SELECT PROCESS_REVISION
595: FROM MTL_RTG_ITEM_REVISIONS MIR, ENG_REVISED_ITEMS ERI
596: WHERE MIR.INVENTORY_ITEM_ID = item_id
597: AND MIR.ORGANIZATION_ID = org_id
598: AND MIR.EFFECTIVITY_DATE <= rev_date --Bug 3020310
599: AND MIR.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID(+)

Line 618: FROM MTL_RTG_ITEM_REVISIONS

614:
615:
616: CURSOR RTG_REV IS
617: SELECT PROCESS_REVISION
618: FROM MTL_RTG_ITEM_REVISIONS
619: WHERE INVENTORY_ITEM_ID = item_id
620: AND ORGANIZATION_ID = org_id
621: -- AND trunc(EFFECTIVITY_DATE) <= trunc(rev_date) -- changed for bug 2631052
622: AND EFFECTIVITY_DATE <= rev_date

Line 805: FROM MTL_RTG_ITEM_REVISIONS

801: AND ORGANIZATION_ID = org_id;
802:
803: CURSOR RTG_REV IS
804: SELECT EFFECTIVITY_DATE
805: FROM MTL_RTG_ITEM_REVISIONS
806: WHERE INVENTORY_ITEM_ID = item_id
807: AND PROCESS_REVISION = itm_rev
808: AND ORGANIZATION_ID = org_id;
809:

Line 935: FROM MTL_RTG_ITEM_REVISIONS

931: ELSE
932: stmt_num := 3;
933: SELECT MIN(EFFECTIVITY_DATE - 1/(60*60*24))
934: INTO l_rev_date
935: FROM MTL_RTG_ITEM_REVISIONS
936: WHERE INVENTORY_ITEM_ID = item_id
937: AND ORGANIZATION_ID = org_id
938: AND EFFECTIVITY_DATE >
939: (SELECT EFFECTIVITY_DATE

Line 940: FROM MTL_RTG_ITEM_REVISIONS

936: WHERE INVENTORY_ITEM_ID = item_id
937: AND ORGANIZATION_ID = org_id
938: AND EFFECTIVITY_DATE >
939: (SELECT EFFECTIVITY_DATE
940: FROM MTL_RTG_ITEM_REVISIONS
941: WHERE INVENTORY_ITEM_ID = item_id
942: AND ORGANIZATION_ID = org_id
943: AND PROCESS_REVISION = itm_rev);
944: /*

Line 947: FROM MTL_RTG_ITEM_REVISIONS

943: AND PROCESS_REVISION = itm_rev);
944: /*
945: SELECT MIN(EFFECTIVITY_DATE - 60/(60*60*24)) -- changed for bug 2631052
946: INTO l_rev_date
947: FROM MTL_RTG_ITEM_REVISIONS
948: WHERE INVENTORY_ITEM_ID = item_id
949: AND ORGANIZATION_ID = org_id
950: AND trunc(EFFECTIVITY_DATE) >
951: (SELECT trunc(EFFECTIVITY_DATE)

Line 952: FROM MTL_RTG_ITEM_REVISIONS

948: WHERE INVENTORY_ITEM_ID = item_id
949: AND ORGANIZATION_ID = org_id
950: AND trunc(EFFECTIVITY_DATE) >
951: (SELECT trunc(EFFECTIVITY_DATE)
952: FROM MTL_RTG_ITEM_REVISIONS
953: WHERE INVENTORY_ITEM_ID = item_id
954: AND ORGANIZATION_ID = org_id
955: AND PROCESS_REVISION = itm_rev);
956: */

Line 977: FROM MTL_RTG_ITEM_REVISIONS

973: ELSE
974: stmt_num := 5;
975: SELECT GREATEST(EFFECTIVITY_DATE,SYSDATE)
976: INTO l_rev_date
977: FROM MTL_RTG_ITEM_REVISIONS
978: WHERE INVENTORY_ITEM_ID = item_id
979: AND ORGANIZATION_ID = org_id
980: AND PROCESS_REVISION = itm_rev;
981: END IF;

Line 1068: FROM MTL_RTG_ITEM_REVISIONS

1064: ORDER BY EFFECTIVITY_DATE DESC, REVISION DESC;
1065:
1066: CURSOR RTG_REV IS
1067: SELECT PROCESS_REVISION
1068: FROM MTL_RTG_ITEM_REVISIONS
1069: WHERE INVENTORY_ITEM_ID = item_id
1070: AND ORGANIZATION_ID = org_id
1071: AND (
1072: (examine_type = 'ALL')