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.CSTPPIPV dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 120: FROM ap_invoice_distributions_all aida,

116: )
117: )
118: AND EXISTS
119: ( SELECT 'X'
120: FROM ap_invoice_distributions_all aida,
121: po_distributions_all pda,
122: po_line_locations_all plla,
123: po_lines_all pla
124: WHERE aida.po_distribution_id = pda.po_distribution_id

Line 351: UPDATE ap_invoice_distributions_all aida

347: -- between aida and aida2 for performance improvement - bug4137765
348: ----------------------------------------------------------------------
349: l_stmt_num := 25;
350:
351: UPDATE ap_invoice_distributions_all aida
352: SET aida.inventory_transfer_status = NULL
353: WHERE po_distribution_id IS NOT NULL
354: /*AND aida.line_type_lookup_code IN ('ITEM','ACCRUAL','NONREC_TAX') */
355: /*Bug 9823230: Commented as per internal discussion to enhance performance and set transfer status

Line 363: FROM ap_invoice_distributions_all aida2

359: AND aida.accounting_date <= l_cutoff_date
360: AND NOT EXISTS
361: (
362: SELECT 'X'
363: FROM ap_invoice_distributions_all aida2
364: WHERE
365: (
366: (
367: aida2.line_type_lookup_code = 'IPV'

Line 873: FROM ap_invoice_distributions_all aida

869: p_project_id)
870: and rownum <2) ))
871: AND EXISTS (
872: SELECT 'X'
873: FROM ap_invoice_distributions_all aida
874: WHERE aida.po_distribution_id = pda.po_distribution_id
875: AND aida.posted_flag = 'Y'
876: AND aida.accounting_date < l_cutoff_date
877: AND aida.inventory_transfer_status = 'N'

Line 1053: UPDATE ap_invoice_distributions_all aida

1049:
1050: forall i in l_po_dists_tab.first..l_po_dists_tab.last
1051:
1052:
1053: UPDATE ap_invoice_distributions_all aida
1054: SET aida.inventory_transfer_status = 'S'
1055: WHERE aida.inventory_transfer_status = 'N'
1056: AND aida.posted_flag = 'Y'
1057: AND aida.accounting_date <= p_cutoff_date

Line 1078: UPDATE ap_invoice_distributions_all aida

1074: ----------------------------------------------------------------------
1075:
1076: l_stmt_num := 25;
1077:
1078: UPDATE ap_invoice_distributions_all aida
1079: SET aida.inventory_transfer_status = NULL
1080: WHERE po_distribution_id IS NOT NULL
1081: /*AND aida.line_type_lookup_code IN ('ITEM','ACCRUAL','NONREC_TAX') */
1082: /* Bug 9823230: Commented as per internal discussion to enhance performance and set transfer status

Line 1090: FROM ap_invoice_distributions_all aida2

1086: AND aida.accounting_date <= l_cutoff_date
1087: AND NOT EXISTS --same change as earlier
1088: (
1089: SELECT 'X'
1090: FROM ap_invoice_distributions_all aida2
1091: WHERE
1092: (
1093: (
1094: aida2.line_type_lookup_code = 'IPV'

Line 1631: -- No {base_}invoice_price_variance columns in ap_invoice_distributions_all

1627: -- Get all relevant records
1628: ---------------------------------------------------------------------
1629: ---------------------------------------------------------------------
1630: -- Invoice Lines Project:
1631: -- No {base_}invoice_price_variance columns in ap_invoice_distributions_all
1632: -- IPV is a separate distribution, therefore the query needs to have a
1633: -- self-join on the table to get the IPV information in addition to the
1634: -- ITEM/ACCRUAL information
1635: -- Added a filter of accounting date and posted flag on aida and join of

Line 1696: FROM ap_invoice_distributions_all aida,

1692: p_prog_id,
1693: SYSDATE,
1694: p_login_id,
1695: p_cost_group_id
1696: FROM ap_invoice_distributions_all aida,
1697: ap_invoice_distributions_all aida2,
1698: po_distributions pda
1699: WHERE aida.posted_flag = 'Y'
1700: AND aida.accounting_date <= p_cutoff_date

Line 1697: ap_invoice_distributions_all aida2,

1693: SYSDATE,
1694: p_login_id,
1695: p_cost_group_id
1696: FROM ap_invoice_distributions_all aida,
1697: ap_invoice_distributions_all aida2,
1698: po_distributions pda
1699: WHERE aida.posted_flag = 'Y'
1700: AND aida.accounting_date <= p_cutoff_date
1701: AND aida2.posted_flag = 'Y'

Line 1884: UPDATE ap_invoice_distributions_all aida

1880: ---------------------------------------------------------------------
1881:
1882: l_stmt_num := 35;
1883:
1884: UPDATE ap_invoice_distributions_all aida
1885: SET aida.inventory_transfer_status = NULL
1886: WHERE aida.inventory_transfer_status = 'N' --Perf Bug 1866130
1887: -- Line below is not needed because cst_ap_variance_lines won't have null IPV
1888: --AND NVL(aida.base_invoice_price_variance,0) <> 0

Line 2027: FROM ap_invoice_distributions_all aida,

2023: p_prog_id,
2024: SYSDATE,
2025: p_login_id,
2026: NULL
2027: FROM ap_invoice_distributions_all aida,
2028: ap_invoice_distributions_all aida2
2029: WHERE aida.posted_flag = 'Y'
2030: AND aida.accounting_date < p_cutoff_date
2031: AND aida2.posted_flag = 'Y'

Line 2028: ap_invoice_distributions_all aida2

2024: SYSDATE,
2025: p_login_id,
2026: NULL
2027: FROM ap_invoice_distributions_all aida,
2028: ap_invoice_distributions_all aida2
2029: WHERE aida.posted_flag = 'Y'
2030: AND aida.accounting_date < p_cutoff_date
2031: AND aida2.posted_flag = 'Y'
2032: AND aida2.accounting_date < p_cutoff_date

Line 2159: UPDATE ap_invoice_distributions_all aida

2155:
2156: l_stmt_num := 35;
2157:
2158: IF (p_transaction_process_mode = 1) THEN
2159: UPDATE ap_invoice_distributions_all aida
2160: SET aida.inventory_transfer_status = NULL
2161: WHERE aida.inventory_transfer_status = 'N' --Perf Bug 1866130
2162: -- AND NVL(aida.base_invoice_price_variance,0) <> 0 Not needed
2163: AND aida.posted_flag = 'Y'