APPS.CSTPPIPV dependencies on CST_AP_VARIANCE_LINES

Line 1607: FROM cst_ap_variance_lines cavl

1603: IS
1604:
1605: SELECT cavl.po_distribution_id,
1606: SUM(NVL(cavl.var_amount,0)) var_amount
1607: FROM cst_ap_variance_lines cavl
1608: WHERE cavl.batch_id = p_batch_id
1609: AND cavl.cost_group_id = p_cost_group_id
1610: AND cavl.inventory_item_id = p_inventory_item_id
1611: GROUP BY cavl.po_distribution_id;

Line 1643: INSERT INTO cst_ap_variance_lines

1639: /* bug 4873742 -- performance repository issues */
1640:
1641: l_stmt_num := 5;
1642:
1643: INSERT INTO cst_ap_variance_lines
1644: (
1645: variance_header_id,
1646: variance_line_id,
1647: batch_id,

Line 1672: cst_ap_variance_lines_s.nextval variance_line_id,

1668: )
1669: (
1670: SELECT
1671: -1 variance_header_id,
1672: cst_ap_variance_lines_s.nextval variance_line_id,
1673: p_batch_id batch_id,
1674: aida.invoice_distribution_id
1675: invoice_distribution_id,
1676: aida.invoice_id invoice_id,

Line 1861: UPDATE cst_ap_variance_lines cavl

1857: ---------------------------------------------------------------------
1858:
1859: l_stmt_num := 30;
1860:
1861: UPDATE cst_ap_variance_lines cavl
1862: SET cavl.variance_header_id =
1863: (SELECT cavh.variance_header_id
1864: FROM cst_ap_variance_headers cavh
1865: WHERE cavh.batch_id = cavl.batch_id

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

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
1889: AND EXISTS
1890: ( SELECT 'X'
1891: FROM cst_ap_variance_lines cavl

Line 1891: FROM cst_ap_variance_lines cavl

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
1889: AND EXISTS
1890: ( SELECT 'X'
1891: FROM cst_ap_variance_lines cavl
1892: WHERE cavl.batch_id = p_batch_id
1893: AND cavl.invoice_distribution_id =
1894: aida.invoice_distribution_id
1895: AND cavl.cost_group_id = p_cost_group_id

Line 1979: cst_ap_variance_lines (

1975:
1976: l_stmt_num := 5;
1977:
1978: INSERT INTO
1979: cst_ap_variance_lines (
1980: variance_header_id,
1981: variance_line_id,
1982: batch_id,
1983: invoice_distribution_id,

Line 2005: cst_ap_variance_lines_s.nextval,

2001: last_update_login,
2002: cost_group_id)
2003: (
2004: SELECT -1,
2005: cst_ap_variance_lines_s.nextval,
2006: p_batch_id,
2007: aida.invoice_distribution_id,
2008: aida.invoice_id,
2009: aida.distribution_line_number,

Line 2093: FROM cst_ap_variance_lines cavl

2089: l_stmt_num := 20;
2090:
2091: SELECT SUM(NVL(cavl.var_amount,0))
2092: INTO l_var_amount
2093: FROM cst_ap_variance_lines cavl
2094: WHERE cavl.batch_id = p_batch_id
2095: AND cavl.po_distribution_id = p_po_distribution_id;
2096:
2097: SELECT cst_ap_variance_headers_s.nextval

Line 2147: UPDATE cst_ap_variance_lines cavl

2143: ---------------------------------------------------------------------
2144:
2145: l_stmt_num := 30;
2146:
2147: UPDATE cst_ap_variance_lines cavl
2148: SET cavl.variance_header_id = l_header_id
2149: WHERE cavl.batch_id = p_batch_id
2150: AND cavl.po_distribution_id = p_po_distribution_id;
2151:

Line 2166: FROM cst_ap_variance_lines cavl

2162: -- AND NVL(aida.base_invoice_price_variance,0) <> 0 Not needed
2163: AND aida.posted_flag = 'Y'
2164: AND EXISTS
2165: ( SELECT 'X'
2166: FROM cst_ap_variance_lines cavl
2167: WHERE cavl.batch_id = p_batch_id
2168: AND cavl.invoice_distribution_id = aida.invoice_distribution_id
2169: );
2170: