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_ALL

Line 1251: po_lines_all pla

1247: IS
1248: SELECT pll.line_location_id
1249: FROM po_line_locations_merge_v pll,
1250: po_lines_interface pli,
1251: po_lines_all pla
1252: WHERE pll.po_line_id = p_po_line_id
1253: AND pll.draft_id = l_draft_id
1254: AND pli.interface_header_id =
1255: po_autocreate_params.g_po_header_id

Line 2060: FROM po_lines_all

2056:
2057: CURSOR c_clin
2058: IS
2059: SELECT po_line_id, line_num_display
2060: FROM po_lines_all
2061: WHERE po_header_id = po_autocreate_params.g_po_header_id
2062: AND group_line_id IS NULL
2063: ORDER BY line_num;
2064:

Line 2068: FROM po_lines_all

2064:
2065: CURSOR c_info_slin (p_group_line_id NUMBER)
2066: IS
2067: SELECT po_line_id, line_num_display
2068: FROM po_lines_all
2069: WHERE po_header_id = po_autocreate_params.g_po_header_id
2070: AND group_line_id = p_group_line_id
2071: AND NVL (clm_info_flag, 'N') = 'Y'
2072: ORDER BY line_num;

Line 2077: FROM po_lines_all

2073:
2074: CURSOR c_priced_slin (p_group_line_id NUMBER)
2075: IS
2076: SELECT po_line_id, line_num_display
2077: FROM po_lines_all
2078: WHERE po_header_id = po_autocreate_params.g_po_header_id
2079: AND group_line_id = p_group_line_id
2080: AND NVL (clm_info_flag, 'N') = 'N'
2081: ORDER BY line_num;

Line 2086: FROM po_lines_all PARENT, po_lines_all CHILD

2082:
2083: CURSOR c_mismatch
2084: IS
2085: SELECT PARENT.line_num_display, CHILD.po_line_id
2086: FROM po_lines_all PARENT, po_lines_all CHILD
2087: WHERE PARENT.po_header_id = po_autocreate_params.g_po_header_id
2088: AND PARENT.group_line_id IS NULL
2089: AND CHILD.po_header_id = po_autocreate_params.g_po_header_id
2090: AND CHILD.group_line_id IS NOT NULL

Line 2137: UPDATE po_lines_all pla

2133: THEN
2134: -- use requisition numbers
2135: l_progress := '035';
2136:
2137: UPDATE po_lines_all pla
2138: SET pla.line_num_display =
2139: (SELECT prl.line_num_display
2140: FROM po_requisition_lines_all prl,
2141: po_lines_interface pli

Line 2157: UPDATE po_lines_all

2153: l_clin_num := '0001';
2154:
2155: FOR clin_rec IN c_clin
2156: LOOP
2157: UPDATE po_lines_all
2158: SET line_num_display = l_clin_num
2159: WHERE po_line_id = clin_rec.po_line_id
2160: AND line_num_display IS NULL;
2161:

Line 2166: UPDATE po_lines_all

2162: l_info_slin_num := l_clin_num || '01';
2163:
2164: FOR info_slin_rec IN c_info_slin (clin_rec.po_line_id)
2165: LOOP
2166: UPDATE po_lines_all
2167: SET line_num_display = l_info_slin_num
2168: WHERE po_line_id = info_slin_rec.po_line_id;
2169:
2170: l_info_slin_num :=

Line 2179: UPDATE po_lines_all

2175: l_priced_slin_num := l_clin_num || 'AA';
2176:
2177: FOR priced_slin_rec IN c_priced_slin (clin_rec.po_line_id)
2178: LOOP
2179: UPDATE po_lines_all
2180: SET line_num_display = l_priced_slin_num
2181: WHERE po_line_id = priced_slin_rec.po_line_id;
2182:
2183: l_priced_slin_num :=

Line 2227: UPDATE po_lines_all

2223: (po_autocreate_params.g_po_header_id,
2224: 'PO'
2225: );
2226:
2227: UPDATE po_lines_all
2228: SET line_num_display = l_clin_num
2229: WHERE po_line_id = clin_rec.po_line_id;
2230:
2231: l_info_slin_num := l_clin_num || '01';

Line 2235: UPDATE po_lines_all

2231: l_info_slin_num := l_clin_num || '01';
2232:
2233: FOR info_slin_rec IN c_info_slin (clin_rec.po_line_id)
2234: LOOP
2235: UPDATE po_lines_all
2236: SET line_num_display = l_info_slin_num
2237: WHERE po_line_id = info_slin_rec.po_line_id;
2238:
2239: l_info_slin_num :=

Line 2248: UPDATE po_lines_all

2244: l_priced_slin_num := l_clin_num || 'AA';
2245:
2246: FOR priced_slin_rec IN c_priced_slin (clin_rec.po_line_id)
2247: LOOP
2248: UPDATE po_lines_all
2249: SET line_num_display = l_priced_slin_num
2250: WHERE po_line_id = priced_slin_rec.po_line_id;
2251:
2252: l_priced_slin_num :=

Line 2285: UPDATE po_lines_all

2281: (po_autocreate_params.g_po_header_id,
2282: 'PO'
2283: );
2284:
2285: UPDATE po_lines_all
2286: SET line_num_display = l_clin_num
2287: WHERE po_line_id = clin_rec.po_line_id;
2288:
2289: l_info_slin_num := l_clin_num || '01';

Line 2293: UPDATE po_lines_all

2289: l_info_slin_num := l_clin_num || '01';
2290:
2291: FOR info_slin_rec IN c_info_slin (clin_rec.po_line_id)
2292: LOOP
2293: UPDATE po_lines_all
2294: SET line_num_display = l_info_slin_num
2295: WHERE po_line_id = info_slin_rec.po_line_id;
2296:
2297: l_info_slin_num :=

Line 2306: UPDATE po_lines_all

2302: l_priced_slin_num := l_clin_num || 'AA';
2303:
2304: FOR priced_slin_rec IN c_priced_slin (clin_rec.po_line_id)
2305: LOOP
2306: UPDATE po_lines_all
2307: SET line_num_display = l_priced_slin_num
2308: WHERE po_line_id = priced_slin_rec.po_line_id;
2309:
2310: l_priced_slin_num :=

Line 2323: UPDATE po_lines_all pla

2319:
2320: -- If there is a mismatch is between clin number/SLIn number. Correct It.
2321: FOR mis_rec IN c_mismatch
2322: LOOP
2323: UPDATE po_lines_all pla
2324: SET pla.line_num_display =
2325: mis_rec.line_num_display
2326: || SUBSTR (pla.line_num_display, 5, 2)
2327: WHERE pla.po_line_id = mis_rec.po_line_id;

Line 2659: INSERT INTO po_lines_all

2655: WHERE po_line_id = p_po_line_id
2656: AND draft_id = p_draft_id;
2657: ELSE
2658: l_progress := '040';
2659: INSERT INTO po_lines_all
2660: (
2661: po_line_id,
2662: last_update_date,
2663: last_updated_by,

Line 2692: FROM po_lines_all

2688: ,org_id
2689: ,po_line_id
2690: ,'Y'
2691: ,uda_template_id --
2692: FROM po_lines_all
2693: WHERE po_line_id = p_po_line_id;
2694: END IF;
2695:
2696: