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 722: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

718: AND fnd_date.canonical_to_date(P_Date_To)
719: AND ((dist.line_type_lookup_code = 'AWT')
720: OR
721: (dist.awt_group_id is not NULL))
722: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
723: dist.ACCRUAL_POSTED_FLAG,
724: dist.CASH_POSTED_FLAG,
725: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
726: -- bug 5207771 Added legal_entity id as 4th parameter, above line

Line 826: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

822: AND fnd_date.canonical_to_date(P_Date_To)
823: AND ((dist.line_type_lookup_code = 'AWT')
824: OR
825: (dist.awt_group_id is not NULL))
826: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
827: dist.ACCRUAL_POSTED_FLAG,
828: dist.CASH_POSTED_FLAG,
829: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
830: -- bug 5207771 Added legal_entity id as 4th parameter, above line

Line 940: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

936: between
937: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
938: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
939: AND (dist.line_type_lookup_code = 'AWT')
940: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
941: DIST.ACCRUAL_POSTED_FLAG,
942: DIST.CASH_POSTED_FLAG,
943: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
944: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 1107: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

1103: between
1104: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1105: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1106: AND (dist.line_type_lookup_code = 'AWT')
1107: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1108: DIST.ACCRUAL_POSTED_FLAG,
1109: DIST.CASH_POSTED_FLAG,
1110: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
1111: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 1250: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

1246: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1247: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1248: AND dist.awt_invoice_payment_id = invpay.invoice_payment_id
1249: AND (dist.line_type_lookup_code = 'AWT')
1250: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1251: DIST.ACCRUAL_POSTED_FLAG,
1252: DIST.CASH_POSTED_FLAG,
1253: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
1254: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 1384: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

1380: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1381: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1382: AND dist.awt_invoice_payment_id = invpay.invoice_payment_id
1383: AND (dist.line_type_lookup_code = 'AWT')
1384: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1385: DIST.ACCRUAL_POSTED_FLAG,
1386: DIST.CASH_POSTED_FLAG,
1387: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
1388: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 1493: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

1489: between
1490: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1491: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1492: AND (dist.line_type_lookup_code = 'AWT')
1493: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1494: DIST.ACCRUAL_POSTED_FLAG,
1495: DIST.CASH_POSTED_FLAG,
1496: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
1497: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 1657: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

1653: between
1654: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1655: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1656: AND (dist.line_type_lookup_code = 'AWT')
1657: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1658: DIST.ACCRUAL_POSTED_FLAG,
1659: DIST.CASH_POSTED_FLAG,
1660: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
1661: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 1780: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

1776: AND trunc(dist.accounting_date,'DD')
1777: between fnd_date.canonical_to_date(P_Date_From)
1778: and fnd_date.canonical_to_date(P_Date_To)
1779: AND dist.line_type_lookup_code = 'AWT'
1780: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1781: DIST.ACCRUAL_POSTED_FLAG,
1782: DIST.CASH_POSTED_FLAG,
1783: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
1784: AND dist.withholding_tax_code_id = atc.tax_id(+)

Line 1905: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

1901: AND trunc(dist.accounting_date,'DD')
1902: between fnd_date.canonical_to_date(P_Date_From)
1903: and fnd_date.canonical_to_date(P_Date_To)
1904: AND dist.line_type_lookup_code = 'AWT'
1905: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1906: DIST.ACCRUAL_POSTED_FLAG,
1907: DIST.CASH_POSTED_FLAG,
1908: dist.POSTED_FLAG, inv.org_id) in ('Y','P')
1909: AND dist.withholding_tax_code_id = atc.tax_id(+)