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.inventory_transfer_status = 'N'
355: AND aida.posted_flag = 'Y' --BUG#5709567-FPBUG#5109100

Line 360: FROM ap_invoice_distributions_all aida2

356: AND aida.accounting_date <= l_cutoff_date
357: AND NOT EXISTS
358: (
359: SELECT 'X'
360: FROM ap_invoice_distributions_all aida2
361: WHERE aida2.line_type_lookup_code = 'IPV'
362: AND aida2.related_id = aida.invoice_distribution_id
363: AND aida.invoice_id = aida2.invoice_id
364: );

Line 849: FROM ap_invoice_distributions_all aida

845: p_project_id)
846: and rownum <2) ))
847: AND EXISTS (
848: SELECT 'X'
849: FROM ap_invoice_distributions_all aida
850: WHERE aida.po_distribution_id = pda.po_distribution_id
851: AND aida.posted_flag = 'Y'
852: AND aida.accounting_date < l_cutoff_date
853: AND aida.inventory_transfer_status = 'N'

Line 1029: UPDATE ap_invoice_distributions_all aida

1025:
1026: forall i in l_po_dists_tab.first..l_po_dists_tab.last
1027:
1028:
1029: UPDATE ap_invoice_distributions_all aida
1030: SET aida.inventory_transfer_status = 'S'
1031: WHERE aida.inventory_transfer_status = 'N'
1032: AND aida.posted_flag = 'Y'
1033: AND aida.accounting_date <= p_cutoff_date

Line 1054: UPDATE ap_invoice_distributions_all aida

1050: ----------------------------------------------------------------------
1051:
1052: l_stmt_num := 25;
1053:
1054: UPDATE ap_invoice_distributions_all aida
1055: SET aida.inventory_transfer_status = NULL
1056: WHERE po_distribution_id IS NOT NULL
1057: AND aida.inventory_transfer_status = 'N'
1058: AND aida.posted_flag = 'Y'

Line 1063: FROM ap_invoice_distributions_all aida2

1059: AND aida.accounting_date <= l_cutoff_date
1060: AND NOT EXISTS --same change as earlier
1061: (
1062: SELECT 'X'
1063: FROM ap_invoice_distributions_all aida2
1064: WHERE aida2.line_type_lookup_code = 'IPV'
1065: AND aida2.related_id = aida.invoice_distribution_id
1066: AND aida.accounting_date <= l_cutoff_date
1067: AND aida.invoice_id = aida2.invoice_id

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

1581: -- Get all relevant records
1582: ---------------------------------------------------------------------
1583: ---------------------------------------------------------------------
1584: -- Invoice Lines Project:
1585: -- No {base_}invoice_price_variance columns in ap_invoice_distributions_all
1586: -- IPV is a separate distribution, therefore the query needs to have a
1587: -- self-join on the table to get the IPV information in addition to the
1588: -- ITEM/ACCRUAL information
1589: -- Added a filter of accounting date and posted flag on aida and join of

Line 1650: FROM ap_invoice_distributions_all aida,

1646: p_prog_id,
1647: SYSDATE,
1648: p_login_id,
1649: p_cost_group_id
1650: FROM ap_invoice_distributions_all aida,
1651: ap_invoice_distributions_all aida2,
1652: po_distributions pda
1653: WHERE aida.posted_flag = 'Y'
1654: AND aida.accounting_date <= p_cutoff_date

Line 1651: ap_invoice_distributions_all aida2,

1647: SYSDATE,
1648: p_login_id,
1649: p_cost_group_id
1650: FROM ap_invoice_distributions_all aida,
1651: ap_invoice_distributions_all aida2,
1652: po_distributions pda
1653: WHERE aida.posted_flag = 'Y'
1654: AND aida.accounting_date <= p_cutoff_date
1655: AND aida2.posted_flag = 'Y'

Line 1818: UPDATE ap_invoice_distributions_all aida

1814: ---------------------------------------------------------------------
1815:
1816: l_stmt_num := 35;
1817:
1818: UPDATE ap_invoice_distributions_all aida
1819: SET aida.inventory_transfer_status = NULL
1820: WHERE aida.inventory_transfer_status = 'N' --Perf Bug 1866130
1821: -- Line below is not needed because cst_ap_variance_lines won't have null IPV
1822: --AND NVL(aida.base_invoice_price_variance,0) <> 0

Line 1961: FROM ap_invoice_distributions_all aida,

1957: p_prog_id,
1958: SYSDATE,
1959: p_login_id,
1960: NULL
1961: FROM ap_invoice_distributions_all aida,
1962: ap_invoice_distributions_all aida2
1963: WHERE aida.posted_flag = 'Y'
1964: AND aida.accounting_date < p_cutoff_date
1965: AND aida2.posted_flag = 'Y'

Line 1962: ap_invoice_distributions_all aida2

1958: SYSDATE,
1959: p_login_id,
1960: NULL
1961: FROM ap_invoice_distributions_all aida,
1962: ap_invoice_distributions_all aida2
1963: WHERE aida.posted_flag = 'Y'
1964: AND aida.accounting_date < p_cutoff_date
1965: AND aida2.posted_flag = 'Y'
1966: AND aida2.accounting_date < p_cutoff_date

Line 2073: UPDATE ap_invoice_distributions_all aida

2069:
2070: l_stmt_num := 35;
2071:
2072: IF (p_transaction_process_mode = 1) THEN
2073: UPDATE ap_invoice_distributions_all aida
2074: SET aida.inventory_transfer_status = NULL
2075: WHERE aida.inventory_transfer_status = 'N' --Perf Bug 1866130
2076: -- AND NVL(aida.base_invoice_price_variance,0) <> 0 Not needed
2077: AND aida.posted_flag = 'Y'