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.PO_AUTOCREATE_POSTPROC_PVT dependencies on PO_LINES_DRAFT_ALL

Line 1783: FROM po_lines_draft_all pla, po_lines_interface pli

1779:
1780: CURSOR c_old_parent
1781: IS
1782: SELECT pla.group_line_id, pla.po_line_id
1783: FROM po_lines_draft_all pla, po_lines_interface pli
1784: WHERE pli.group_line_id IS NOT NULL
1785: AND pli.interface_header_id =
1786: po_autocreate_params.x_interface_header_id
1787: AND pli.line_num = pla.line_num

Line 1794: FROM po_lines_draft_all pla, po_lines_interface pli

1790:
1791: CURSOR c_old_base
1792: IS
1793: SELECT pla.clm_base_line_num, pla.po_line_id
1794: FROM po_lines_draft_all pla, po_lines_interface pli
1795: WHERE pli.clm_base_line_num IS NOT NULL
1796: AND pli.interface_header_id =
1797: po_autocreate_params.x_interface_header_id
1798: AND pli.line_num = pla.line_num

Line 1808: FROM po_lines_draft_all pla,

1804: SELECT pla.line_num_display,
1805: pla.clm_base_line_num,
1806: pla.po_line_id,
1807: rownum --bug 13584453
1808: FROM po_lines_draft_all pla,
1809: po_lines_interface pli
1810: WHERE pli.clm_base_line_num IS NOT NULL
1811: AND pli.interface_header_id = po_autocreate_params.x_interface_header_id
1812: AND pli.line_num = pla.line_num

Line 1828: UPDATE po_lines_draft_all

1824: l_progress := 010;
1825:
1826: FOR l_rec IN c_old_parent
1827: LOOP
1828: UPDATE po_lines_draft_all
1829: SET group_line_id =
1830: (SELECT pla.po_line_id
1831: FROM po_lines_interface pli, po_lines_draft_all pla
1832: WHERE 1 = 1

Line 1831: FROM po_lines_interface pli, po_lines_draft_all pla

1827: LOOP
1828: UPDATE po_lines_draft_all
1829: SET group_line_id =
1830: (SELECT pla.po_line_id
1831: FROM po_lines_interface pli, po_lines_draft_all pla
1832: WHERE 1 = 1
1833: AND pla.po_header_id =
1834: po_autocreate_params.g_po_header_id
1835: AND pla.group_line_id IS NULL

Line 1856: UPDATE po_lines_draft_all

1852: l_progress := 020;
1853:
1854: FOR l_rec IN c_old_base
1855: LOOP
1856: UPDATE po_lines_draft_all
1857: SET clm_base_line_num =
1858: (SELECT pla.po_line_id
1859: FROM po_lines_interface pli, po_lines_draft_all pla
1860: WHERE 1 = 1

Line 1859: FROM po_lines_interface pli, po_lines_draft_all pla

1855: LOOP
1856: UPDATE po_lines_draft_all
1857: SET clm_base_line_num =
1858: (SELECT pla.po_line_id
1859: FROM po_lines_interface pli, po_lines_draft_all pla
1860: WHERE 1 = 1
1861: AND pla.po_header_id =
1862: po_autocreate_params.g_po_header_id
1863: AND pla.clm_base_line_num IS NULL

Line 1873: --Updating the option numbers to po_lines_draft_all

1869: END LOOP;
1870:
1871:
1872: /*CLM Phase-2 : Autocreate Grouping*/
1873: --Updating the option numbers to po_lines_draft_all
1874: FOR l_rec IN c_old_option_line
1875: LOOP
1876: IF g_debug_stmt
1877: THEN

Line 1902: UPDATE po_lines_draft_all

1898: ELSE
1899: l_next_option_num := l_next_option_num + 1;
1900: END IF;
1901:
1902: UPDATE po_lines_draft_all
1903: SET clm_option_num = l_next_option_num
1904: WHERE po_line_id = l_rec.po_line_id
1905: AND draft_id = po_autocreate_params.g_draft_id;
1906:

Line 1938: UPDATE po_lines_draft_all

1934: WHERE clm_base_line_num = l_rec.clm_base_line_num
1935: AND draft_id = l_draft_id
1936: ;
1937:
1938: UPDATE po_lines_draft_all
1939: SET clm_option_num = l_next_option_num + DECODE(l_draft_id, -1, l_rec.rownum, 1)
1940: WHERE po_line_id = l_rec.po_line_id
1941: AND draft_id = po_autocreate_params.g_draft_id;
1942:

Line 1972: FROM po_lines_draft_all pld , po_lines_interface PLI

1968: l_progress := 30;
1969:
1970: UPDATE po_distributions_draft_all pda
1971: SET group_line_id = ( SELECT pld.po_line_id
1972: FROM po_lines_draft_all pld , po_lines_interface PLI
1973: WHERE pld.draft_id = po_autocreate_params.g_draft_id
1974: AND pld.po_header_id = po_autocreate_params.g_po_header_id
1975: AND pld.line_num = pli.line_num
1976: AND PLI.interface_line_id = pda.group_line_id

Line 2372: FROM po_lines_draft_all pld, po_lines_interface PLI

2368: CURSOR c_lines
2369: IS
2370:
2371: SELECT pld.po_line_id
2372: FROM po_lines_draft_all pld, po_lines_interface PLI
2373: WHERE pld.uda_template_id IS NULL
2374: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
2375: AND PLD.po_header_id = po_autocreate_params.g_po_header_id
2376: AND pld. line_num =PLI.line_num

Line 2384: FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll

2380: CURSOR c_shipments
2381: IS
2382:
2383: SELECT pll.line_location_id
2384: FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll
2385: WHERE pll.uda_template_id IS NULL
2386: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
2387: AND PLD.po_header_id = po_autocreate_params.g_po_header_id
2388: AND pld. line_num =PLI.line_num

Line 2499: UPDATE po_lines_draft_all

2495: ELSIF x_doc_level_tbl(i) = 'LINE' THEN
2496: FOR l_line_rec IN c_lines
2497: LOOP
2498: l_progress := '100';
2499: UPDATE po_lines_draft_all
2500: SET uda_template_id = l_line_uda_tmpl_id
2501: WHERE po_line_id = l_line_rec.po_line_id
2502: AND draft_id = po_autocreate_params.g_draft_id;
2503: END LOOP;

Line 2618: INSERT INTO po_lines_draft_all

2614:
2615:
2616: IF p_draft_id <> -1 THEN
2617: l_progress := '030';
2618: INSERT INTO po_lines_draft_all
2619: ( draft_id,
2620: po_line_id,
2621: last_update_date,
2622: last_updated_by,

Line 2654: FROM po_lines_draft_all

2650: ,po_line_id
2651: ,'Y'
2652: ,'NEW' --Bug 16511873
2653: ,uda_template_id --
2654: FROM po_lines_draft_all
2655: WHERE po_line_id = p_po_line_id
2656: AND draft_id = p_draft_id;
2657: ELSE
2658: l_progress := '040';