APPS.AS_GAR_QOT_PUB dependencies on JTF_RS_SRP_VL

Line 1510: FROM ASO_QUOTE_ACCESSES AQA2, JTF_RS_SRP_Vl SREP1

1506: AND TRANS.trans_object_id = AQH.quote_number
1507: AND NOT EXISTS
1508: (
1509: SELECT 'X'
1510: FROM ASO_QUOTE_ACCESSES AQA2, JTF_RS_SRP_Vl SREP1
1511: WHERE AQH.resource_Id = AQA2.resource_id
1512: AND AQH.quote_number = AQA2.quote_number
1513: AND SREP1.resource_id = AQA2.resource_id
1514: AND NVL(AQA2.update_access_flag,'N') = 'Y'

Line 1519: ) W, JTF_RS_SRP_Vl SREP

1515: AND NVL(SREP1.status,'A') = 'A'
1516: AND NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) <= TRUNC(SYSDATE)
1517: AND NVL(TRUNC(end_date_active), TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
1518: )-- all Q except Q8 (pick only the record which has an invalid resource set in header and access)
1519: ) W, JTF_RS_SRP_Vl SREP
1520: WHERE AQA1.quote_number = W.trans_object_id
1521: AND AQA1.resource_id = SREP.resource_id
1522: AND NVL(AQA1.update_access_flag,'N') ='Y'
1523: AND NVL(SREP.status,'A') = 'A'

Line 1538: FROM ASO_QUOTE_ACCESSES AQA2, JTF_RS_SRP_Vl SREP1

1534: AND TRANS.trans_object_id = AQH.quote_number
1535: AND NOT EXISTS
1536: (
1537: SELECT 'X'
1538: FROM ASO_QUOTE_ACCESSES AQA2, JTF_RS_SRP_Vl SREP1
1539: WHERE AQH.resource_Id = AQA2.resource_id
1540: AND AQH.quote_number = AQA2.quote_number
1541: AND SREP1.resource_id = AQA2.resource_id
1542: AND NVL(AQA2.update_access_flag,'N') = 'Y'

Line 1547: ) W, JTF_RS_SRP_Vl SREP

1543: AND NVL(SREP1.status,'A') = 'A'
1544: AND NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) <= TRUNC(SYSDATE)
1545: AND NVL(TRUNC(end_date_active), TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
1546: )-- all Q except Q8 (pick only the record which has an invalid resource set in header and access)
1547: ) W, JTF_RS_SRP_Vl SREP
1548: WHERE AQA1.quote_number = W.trans_object_id
1549: AND AQA1.resource_id = SREP.resource_id
1550: AND NVL(AQA1.update_access_flag,'N') ='Y'
1551: AND NVL(SREP.status,'A') = 'A'

Line 1569: FROM ASO_QUOTE_ACCESSES AQA2, JTF_RS_SRP_Vl SREP

1565: WHERE worker_id=c_worker_id
1566: AND TRANS.trans_object_id = AQH.quote_number
1567: AND NOT EXISTS
1568: (SELECT 'X'
1569: FROM ASO_QUOTE_ACCESSES AQA2, JTF_RS_SRP_Vl SREP
1570: WHERE SREP.resource_Id = AQA2.resource_id
1571: AND AQH.quote_number = AQA2.quote_number
1572: AND NVL(AQA2.update_access_flag,'N') = 'Y'
1573: AND NVL(SREP.status,'A') = 'A'

Line 1586: FROM ASO_QUOTE_ACCESSES AQA2, JTF_RS_SRP_Vl SREP

1582: WHERE worker_id=c_worker_id
1583: AND TRANS.trans_object_id = AQH.quote_number
1584: AND NOT EXISTS
1585: (SELECT 'X'
1586: FROM ASO_QUOTE_ACCESSES AQA2, JTF_RS_SRP_Vl SREP
1587: WHERE SREP.resource_Id = AQA2.resource_id
1588: AND AQH.quote_number = AQA2.quote_number
1589: AND NVL(AQA2.update_access_flag,'N') = 'Y'
1590: AND NVL(SREP.status,'A') = 'A'