DBA Data[Home] [Help]

APPS.PO_DOCUMENT_TOTALS_PVT dependencies on PO_LINES_ALL

Line 226: FROM po_lines_merge_v pol -- Changed from po_lines_all

222: nvl2(l_mau
223: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
224: , round((pol.quantity*pol.unit_price),l_precision)) )) -- Bug# 5378134
225: INTO l_return_val
226: FROM po_lines_merge_v pol -- Changed from po_lines_all
227: WHERE pol.po_header_id = p_doc_level_id
228: AND pol.draft_id = p_draft_id;
229:
230: ELSIF p_data_source = g_data_source_ARCHIVE THEN

Line 277: FROM po_lines_merge_v pol -- Changed from po_lines_all

273: nvl2(l_mau
274: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
275: , round((pol.quantity*pol.unit_price),l_precision)) ) -- Bug# 5378134
276: INTO l_return_val
277: FROM po_lines_merge_v pol -- Changed from po_lines_all
278: WHERE pol.po_line_id = p_doc_level_id
279: AND pol.draft_id = p_draft_id;
280:
281: ELSIF p_data_source = g_data_source_ARCHIVE THEN

Line 1149: l_org_id PO_LINES_ALL.org_id%type;

1145: d_mod CONSTANT VARCHAR2(100) :=
1146: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountBilledForLine');
1147: d_position NUMBER := 0;
1148: l_return_val NUMBER := 0;
1149: l_org_id PO_LINES_ALL.org_id%type;
1150: BEGIN
1151:
1152: IF PO_LOG.d_proc THEN
1153: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 1162: FROM po_lines_all pol

1158: d_position := 10;
1159:
1160: SELECT pol.org_id
1161: INTO l_org_id
1162: FROM po_lines_all pol
1163: WHERE pol.po_line_id = p_line_id;
1164:
1165: d_position := 20;
1166: IF PO_LOG.d_stmt THEN

Line 1432: l_org_id PO_LINES_ALL.org_id%type;

1428: d_mod CONSTANT VARCHAR2(100) :=
1429: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountFinancedForLine');
1430: d_position NUMBER := 0;
1431: l_return_val NUMBER := 0;
1432: l_org_id PO_LINES_ALL.org_id%type;
1433: BEGIN
1434:
1435: IF PO_LOG.d_proc THEN
1436: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 1445: FROM po_lines_all pol

1441: d_position := 10;
1442:
1443: SELECT pol.org_id
1444: INTO l_org_id
1445: FROM po_lines_all pol
1446: WHERE pol.po_line_id = p_line_id;
1447:
1448: d_position := 20;
1449: IF PO_LOG.d_stmt THEN

Line 1712: l_org_id PO_LINES_ALL.org_id%type;

1708: d_mod CONSTANT VARCHAR2(100) :=
1709: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRecoupedForLine');
1710: d_position NUMBER := 0;
1711: l_return_val NUMBER := 0;
1712: l_org_id PO_LINES_ALL.org_id%type;
1713: BEGIN
1714:
1715: IF PO_LOG.d_proc THEN
1716: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 1725: FROM po_lines_all pol

1721: d_position := 10;
1722:
1723: SELECT pol.org_id
1724: INTO l_org_id
1725: FROM po_lines_all pol
1726: WHERE pol.po_line_id = p_line_id;
1727:
1728: d_position := 20;
1729: IF PO_LOG.d_stmt THEN

Line 1990: l_org_id PO_LINES_ALL.org_id%type;

1986: d_mod CONSTANT VARCHAR2(100) :=
1987: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRetainedForLine');
1988: d_position NUMBER := 0;
1989: l_return_val NUMBER := 0;
1990: l_org_id PO_LINES_ALL.org_id%type;
1991: BEGIN
1992:
1993: IF PO_LOG.d_proc THEN
1994: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 2003: FROM po_lines_all pol

1999: d_position := 10;
2000:
2001: SELECT pol.org_id
2002: INTO l_org_id
2003: FROM po_lines_all pol
2004: WHERE pol.po_line_id = p_line_id;
2005:
2006: d_position := 20;
2007: IF PO_LOG.d_stmt THEN

Line 2275: FROM po_lines_merge_v pol -- Changed from po_lines_all

2271: d_position := 10;
2272:
2273: SELECT pol.po_header_id
2274: INTO l_header_id
2275: FROM po_lines_merge_v pol -- Changed from po_lines_all
2276: WHERE pol.po_line_id = p_line_id
2277: AND pol.draft_id = p_draft_id;
2278:
2279: d_position := 20;

Line 2316: FROM po_lines_merge_v pol -- Changed from po_lines_all

2312: d_position := 40;
2313:
2314: SELECT nvl(pol.quantity, 0)
2315: INTO l_return_val
2316: FROM po_lines_merge_v pol -- Changed from po_lines_all
2317: WHERE pol.po_line_id = p_line_id
2318: AND pol.draft_id = p_draft_id;
2319:
2320: END IF;

Line 4379: FROM po_lines_merge_v pol -- Changed from po_lines_all

4375: nvl2(l_mau
4376: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
4377: , round((pol.quantity*pol.unit_price),l_precision)) ))
4378: INTO l_return_val
4379: FROM po_lines_merge_v pol -- Changed from po_lines_all
4380: WHERE pol.po_header_id = p_doc_level_id
4381: AND pol.draft_id = p_draft_id
4382: AND (NVL(pol.clm_option_indicator,'N') <> 'O'
4383: OR pol.clm_exercised_flag = 'Y'); --

Line 4432: FROM po_lines_merge_v pol -- Changed from po_lines_all

4428: nvl2(l_mau
4429: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
4430: , round((pol.quantity*pol.unit_price),l_precision)) )
4431: INTO l_return_val
4432: FROM po_lines_merge_v pol -- Changed from po_lines_all
4433: WHERE pol.po_line_id = p_doc_level_id
4434: AND pol.draft_id = p_draft_id
4435: AND (NVL(pol.clm_option_indicator,'N') <> 'O'
4436: OR pol.clm_exercised_flag = 'Y'); --