APPS.CSTPPIPV dependencies on CST_AP_VARIANCE_LINES

Line 1561: FROM cst_ap_variance_lines cavl

1557: IS
1558:
1559: SELECT cavl.po_distribution_id,
1560: SUM(NVL(cavl.var_amount,0)) var_amount
1561: FROM cst_ap_variance_lines cavl
1562: WHERE cavl.batch_id = p_batch_id
1563: AND cavl.cost_group_id = p_cost_group_id
1564: AND cavl.inventory_item_id = p_inventory_item_id
1565: GROUP BY cavl.po_distribution_id;

Line 1597: INSERT INTO cst_ap_variance_lines

1593: /* bug 4873742 -- performance repository issues */
1594:
1595: l_stmt_num := 5;
1596:
1597: INSERT INTO cst_ap_variance_lines
1598: (
1599: variance_header_id,
1600: variance_line_id,
1601: batch_id,

Line 1626: cst_ap_variance_lines_s.nextval variance_line_id,

1622: )
1623: (
1624: SELECT
1625: -1 variance_header_id,
1626: cst_ap_variance_lines_s.nextval variance_line_id,
1627: p_batch_id batch_id,
1628: aida.invoice_distribution_id
1629: invoice_distribution_id,
1630: aida.invoice_id invoice_id,

Line 1795: UPDATE cst_ap_variance_lines cavl

1791: ---------------------------------------------------------------------
1792:
1793: l_stmt_num := 30;
1794:
1795: UPDATE cst_ap_variance_lines cavl
1796: SET cavl.variance_header_id =
1797: (SELECT cavh.variance_header_id
1798: FROM cst_ap_variance_headers cavh
1799: WHERE cavh.batch_id = cavl.batch_id

Line 1821: -- Line below is not needed because cst_ap_variance_lines won't have null IPV

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
1823: AND EXISTS
1824: ( SELECT 'X'
1825: FROM cst_ap_variance_lines cavl

Line 1825: FROM cst_ap_variance_lines cavl

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
1823: AND EXISTS
1824: ( SELECT 'X'
1825: FROM cst_ap_variance_lines cavl
1826: WHERE cavl.batch_id = p_batch_id
1827: AND cavl.invoice_distribution_id =
1828: aida.invoice_distribution_id
1829: AND cavl.cost_group_id = p_cost_group_id

Line 1913: cst_ap_variance_lines (

1909:
1910: l_stmt_num := 5;
1911:
1912: INSERT INTO
1913: cst_ap_variance_lines (
1914: variance_header_id,
1915: variance_line_id,
1916: batch_id,
1917: invoice_distribution_id,

Line 1939: cst_ap_variance_lines_s.nextval,

1935: last_update_login,
1936: cost_group_id)
1937: (
1938: SELECT -1,
1939: cst_ap_variance_lines_s.nextval,
1940: p_batch_id,
1941: aida.invoice_distribution_id,
1942: aida.invoice_id,
1943: aida.distribution_line_number,

Line 2007: FROM cst_ap_variance_lines cavl

2003: l_stmt_num := 20;
2004:
2005: SELECT SUM(NVL(cavl.var_amount,0))
2006: INTO l_var_amount
2007: FROM cst_ap_variance_lines cavl
2008: WHERE cavl.batch_id = p_batch_id
2009: AND cavl.po_distribution_id = p_po_distribution_id;
2010:
2011: SELECT cst_ap_variance_headers_s.nextval

Line 2061: UPDATE cst_ap_variance_lines cavl

2057: ---------------------------------------------------------------------
2058:
2059: l_stmt_num := 30;
2060:
2061: UPDATE cst_ap_variance_lines cavl
2062: SET cavl.variance_header_id = l_header_id
2063: WHERE cavl.batch_id = p_batch_id
2064: AND cavl.po_distribution_id = p_po_distribution_id;
2065:

Line 2080: FROM cst_ap_variance_lines cavl

2076: -- AND NVL(aida.base_invoice_price_variance,0) <> 0 Not needed
2077: AND aida.posted_flag = 'Y'
2078: AND EXISTS
2079: ( SELECT 'X'
2080: FROM cst_ap_variance_lines cavl
2081: WHERE cavl.batch_id = p_batch_id
2082: AND cavl.invoice_distribution_id = aida.invoice_distribution_id
2083: );
2084: