eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_REP_YEP_PVT dependencies on PO_HEADERS_ALL

Line 35: po_headers_all phh,

31: SELECT unique apid.invoice_id
32: FROM
33: ap_invoice_distributions_all apid,
34: po_distributions_all pod,
35: po_headers_all phh,
36: igc_cc_headers cch
37: WHERE
38: apid.po_distribution_id = pod.po_distribution_id AND
39: pod.po_header_id = phh.po_header_id AND

Line 198: FROM PO_HEADERS_ALL A

194: RETURN BOOLEAN AS
195:
196: CURSOR CC(P_CC_HEADER_ID NUMBER) IS
197: SELECT 'Y'
198: FROM PO_HEADERS_ALL A
199: WHERE
200: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
201: FROM IGC_CC_HEADERS B,
202: PO_HEADERS_ALL C

Line 202: PO_HEADERS_ALL C

198: FROM PO_HEADERS_ALL A
199: WHERE
200: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
201: FROM IGC_CC_HEADERS B,
202: PO_HEADERS_ALL C
203: WHERE B.ORG_ID = C.ORG_ID AND
204: B.CC_NUM = C.SEGMENT1 AND
205: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
206: B.CC_HEADER_ID = P_CC_HEADER_ID);

Line 209: FROM PO_HEADERS_ALL A

205: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
206: B.CC_HEADER_ID = P_CC_HEADER_ID);
207: CURSOR CC1(P_CC_HEADER_ID NUMBER) IS
208: SELECT 'Y'
209: FROM PO_HEADERS_ALL A
210: WHERE
211: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
212: FROM IGC_CC_HEADERS B,
213: PO_HEADERS_ALL C

Line 213: PO_HEADERS_ALL C

209: FROM PO_HEADERS_ALL A
210: WHERE
211: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
212: FROM IGC_CC_HEADERS B,
213: PO_HEADERS_ALL C
214: WHERE B.ORG_ID = C.ORG_ID AND
215: B.CC_NUM = C.SEGMENT1 AND
216: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
217: B.CC_HEADER_ID = P_CC_HEADER_ID)

Line 1530: FROM PO_HEADERS_ALL A

1526:
1527: BEGIN
1528: SELECT 'Y'
1529: INTO l_DUMMY
1530: FROM PO_HEADERS_ALL A
1531: WHERE
1532: A.PO_HEADER_ID =
1533: (SELECT C.PO_HEADER_ID
1534: FROM IGC_CC_HEADERS B,

Line 1535: PO_HEADERS_ALL C

1531: WHERE
1532: A.PO_HEADER_ID =
1533: (SELECT C.PO_HEADER_ID
1534: FROM IGC_CC_HEADERS B,
1535: PO_HEADERS_ALL C
1536: WHERE B.ORG_ID = C.ORG_ID AND
1537: B.CC_NUM = C.SEGMENT1 AND
1538: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
1539: B.CC_HEADER_ID = V9.CC_HEADER_ID );

Line 1542: UPDATE PO_HEADERS_ALL

1538: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
1539: B.CC_HEADER_ID = V9.CC_HEADER_ID );
1540:
1541:
1542: UPDATE PO_HEADERS_ALL
1543: SET APPROVED_FLAG = 'N'
1544: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN
1545: (SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
1546: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b

Line 1546: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b

1542: UPDATE PO_HEADERS_ALL
1543: SET APPROVED_FLAG = 'N'
1544: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN
1545: (SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
1546: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
1547: WHERE a.SEGMENT1 = b.CC_NUM
1548: AND a.ORG_ID = b.ORG_ID
1549: AND a.TYPE_LOOKUP_CODE = 'STANDARD'
1550: AND b.CC_HEADER_ID = V9.CC_HEADER_ID);

Line 1764: FROM PO_HEADERS_ALL A

1760:
1761: BEGIN
1762: SELECT 'Y'
1763: INTO l_DUMMY
1764: FROM PO_HEADERS_ALL A
1765: WHERE
1766: A.PO_HEADER_ID =
1767: (SELECT C.PO_HEADER_ID
1768: FROM IGC_CC_HEADERS B,

Line 1769: PO_HEADERS_ALL C

1765: WHERE
1766: A.PO_HEADER_ID =
1767: (SELECT C.PO_HEADER_ID
1768: FROM IGC_CC_HEADERS B,
1769: PO_HEADERS_ALL C
1770: WHERE B.ORG_ID = C.ORG_ID AND
1771: B.CC_NUM = C.SEGMENT1 AND
1772: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
1773: B.CC_HEADER_ID = V9.CC_HEADER_ID );

Line 1776: UPDATE PO_HEADERS_ALL

1772: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
1773: B.CC_HEADER_ID = V9.CC_HEADER_ID );
1774:
1775:
1776: UPDATE PO_HEADERS_ALL
1777: SET APPROVED_FLAG = 'N'
1778: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN
1779: (SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
1780: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b

Line 1780: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b

1776: UPDATE PO_HEADERS_ALL
1777: SET APPROVED_FLAG = 'N'
1778: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN
1779: (SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
1780: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
1781: WHERE a.SEGMENT1 = b.CC_NUM
1782: AND a.ORG_ID = b.ORG_ID
1783: AND a.TYPE_LOOKUP_CODE = 'STANDARD'
1784: AND b.CC_HEADER_ID = V9.CC_HEADER_ID);

Line 1991: FROM PO_HEADERS_ALL A

1987:
1988: BEGIN
1989: SELECT 'Y'
1990: INTO l_DUMMY
1991: FROM PO_HEADERS_ALL A
1992: WHERE
1993: A.PO_HEADER_ID =
1994: (SELECT C.PO_HEADER_ID
1995: FROM IGC_CC_HEADERS B,

Line 1996: PO_HEADERS_ALL C

1992: WHERE
1993: A.PO_HEADER_ID =
1994: (SELECT C.PO_HEADER_ID
1995: FROM IGC_CC_HEADERS B,
1996: PO_HEADERS_ALL C
1997: WHERE B.ORG_ID = C.ORG_ID AND
1998: B.CC_NUM = C.SEGMENT1 AND
1999: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
2000: B.CC_HEADER_ID = V9.CC_HEADER_ID );

Line 2003: UPDATE PO_HEADERS_ALL

1999: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
2000: B.CC_HEADER_ID = V9.CC_HEADER_ID );
2001:
2002:
2003: UPDATE PO_HEADERS_ALL
2004: SET APPROVED_FLAG = 'N'
2005: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN
2006: (SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
2007: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b

Line 2007: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b

2003: UPDATE PO_HEADERS_ALL
2004: SET APPROVED_FLAG = 'N'
2005: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN
2006: (SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
2007: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
2008: WHERE a.SEGMENT1 = b.CC_NUM
2009: AND a.ORG_ID = b.ORG_ID
2010: AND a.TYPE_LOOKUP_CODE = 'STANDARD'
2011: AND b.CC_HEADER_ID = V9.CC_HEADER_ID);

Line 2302: l_po_header_id po_headers_all.po_header_id%TYPE;

2298: l_invoice_id ap_invoices_all.invoice_id%TYPE;
2299: l_cancelled_date ap_invoices_all.cancelled_date%TYPE;
2300: l_payment_status_flag ap_invoices_all.payment_status_flag%TYPE;
2301:
2302: l_po_header_id po_headers_all.po_header_id%TYPE;
2303: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
2304:
2305: l_invoice_canc_paid_flag BOOLEAN := FALSE;
2306:

Line 2312: po_headers_all phh,

2308: IS
2309: SELECT pod.po_distribution_id
2310: FROM
2311: po_distributions_all pod,
2312: po_headers_all phh,
2313: igc_cc_headers cch
2314: WHERE
2315: pod.po_header_id = phh.po_header_id AND
2316: phh.org_id = cch.org_id AND