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.JE_ES_WHTAX dependencies on AP_INVOICE_DISTRIBUTIONS_PKG

Line 749: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

745: AND fnd_date.canonical_to_date(P_Date_To)
746: AND ((dist.line_type_lookup_code = 'AWT')
747: OR
748: (dist.awt_group_id is not NULL))
749: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
750: dist.ACCRUAL_POSTED_FLAG,
751: dist.CASH_POSTED_FLAG,
752: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
753: -- bug 5207771 Added legal_entity id as 4th parameter, above line

Line 869: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

865: AND fnd_date.canonical_to_date(P_Date_To)
866: AND ((dist.line_type_lookup_code = 'AWT')
867: OR
868: (dist.awt_group_id is not NULL))
869: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
870: dist.ACCRUAL_POSTED_FLAG,
871: dist.CASH_POSTED_FLAG,
872: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
873: -- bug 5207771 Added legal_entity id as 4th parameter, above line

Line 1008: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

1004: between
1005: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1006: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1007: AND (dist.line_type_lookup_code = 'AWT')
1008: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1009: DIST.ACCRUAL_POSTED_FLAG,
1010: DIST.CASH_POSTED_FLAG,
1011: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
1012: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 1203: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

1199: between
1200: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1201: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1202: AND (dist.line_type_lookup_code = 'AWT')
1203: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1204: DIST.ACCRUAL_POSTED_FLAG,
1205: DIST.CASH_POSTED_FLAG,
1206: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
1207: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 1378: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

1374: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1375: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1376: AND dist.awt_invoice_payment_id = invpay.invoice_payment_id
1377: AND (dist.line_type_lookup_code = 'AWT')
1378: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1379: DIST.ACCRUAL_POSTED_FLAG,
1380: DIST.CASH_POSTED_FLAG,
1381: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
1382: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 1572: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

1568: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1569: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1570: AND dist.awt_invoice_payment_id = invpay.invoice_payment_id
1571: AND (dist.line_type_lookup_code = 'AWT')
1572: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1573: DIST.ACCRUAL_POSTED_FLAG,
1574: DIST.CASH_POSTED_FLAG,
1575: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
1576: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 1742: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

1738: between
1739: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1740: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1741: AND (dist.line_type_lookup_code = 'AWT')
1742: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1743: DIST.ACCRUAL_POSTED_FLAG,
1744: DIST.CASH_POSTED_FLAG,
1745: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
1746: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 1934: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

1930: between
1931: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1932: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1933: AND (dist.line_type_lookup_code = 'AWT')
1934: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1935: DIST.ACCRUAL_POSTED_FLAG,
1936: DIST.CASH_POSTED_FLAG,
1937: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
1938: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 2087: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

2083: AND trunc(dist.accounting_date,'DD')
2084: between fnd_date.canonical_to_date(P_Date_From)
2085: and fnd_date.canonical_to_date(P_Date_To)
2086: AND dist.line_type_lookup_code = 'AWT'
2087: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
2088: DIST.ACCRUAL_POSTED_FLAG,
2089: DIST.CASH_POSTED_FLAG,
2090: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
2091: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 2240: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

2236: AND trunc(dist.accounting_date,'DD')
2237: between fnd_date.canonical_to_date(P_Date_From)
2238: and fnd_date.canonical_to_date(P_Date_To)
2239: AND dist.line_type_lookup_code = 'AWT'
2240: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
2241: DIST.ACCRUAL_POSTED_FLAG,
2242: DIST.CASH_POSTED_FLAG,
2243: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
2244: AND dist.withholding_tax_code_id = atc.tax_id(+)