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_REQ_LINES_SV dependencies on PO_REQUISITION_LINES_ALL

Line 750: UPDATE po_requisition_lines_all rl -- Bug 3592153

746: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
747: AND s.po_header_id = X_entity_id;
748: --
749:
750: UPDATE po_requisition_lines_all rl -- Bug 3592153
751: SET rl.line_location_id = NULL,
752: --reqs_in_pool_flag = 'Y', -- Bug 2781027 resetting the reqs in pool flag
753: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
754: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)

Line 788: UPDATE po_requisition_lines_all rl -- Bug 3592153

784: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
785: AND s.po_release_id = X_entity_id;
786: --
787:
788: UPDATE po_requisition_lines_all rl -- Bug 3592153
789: SET rl.line_location_id = NULL,
790: --reqs_in_pool_flag = 'Y', -- Bug 2781027
791: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
792: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)

Line 826: UPDATE po_requisition_lines_all rl -- Bug 3592153

822: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
823: AND s.po_line_id = X_entity_id;
824: --
825:
826: UPDATE po_requisition_lines_all rl -- Bug 3592153
827: SET rl.line_location_id = NULL,
828: -- reqs_in_pool_flag = 'Y', -- Bug 2781027
829: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
830: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)

Line 871: UPDATE po_requisition_lines_all rl -- Bug 3592153

867: AND s.line_location_id = X_entity_id;
868: --
869:
870:
871: UPDATE po_requisition_lines_all rl -- Bug 3592153
872: SET rl.line_location_id = NULL,
873: --reqs_in_pool_flag = 'Y', -- Bug 2781027
874: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
875: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)

Line 1257: UPDATE po_requisition_lines_all prl

1253: -- be placed on a purchasing document; those that fail all
1254: -- the above criteria can.
1255: --
1256: --SQL Join: requisition_header_id from PO_REQUISITION_HEADERS_ALL
1257: UPDATE po_requisition_lines_all prl
1258: SET prl.reqs_in_pool_flag =
1259: CASE
1260: WHEN NVL(prl.cancel_flag,'N') = 'Y'
1261: OR NVL(prl.closed_code,'OPEN') = 'FINALLY CLOSED'

Line 1299: FROM PO_REQUISITION_LINES_ALL SUB

1295: , prl.last_update_login = FND_GLOBAL.LOGIN_ID
1296: WHERE
1297: PRL.Requisition_Line_ID in (
1298: SELECT SUB.Requisition_Line_ID
1299: FROM PO_REQUISITION_LINES_ALL SUB
1300: WHERE SUB.Requisition_Header_Id = x_req_header_id
1301: AND x_req_line_id IS NULL
1302: UNION ALL
1303: SELECT SUB2.Requisition_Line_ID

Line 1304: FROM PO_REQUISITION_LINES_ALL SUB2

1300: WHERE SUB.Requisition_Header_Id = x_req_header_id
1301: AND x_req_line_id IS NULL
1302: UNION ALL
1303: SELECT SUB2.Requisition_Line_ID
1304: FROM PO_REQUISITION_LINES_ALL SUB2
1305: WHERE SUB2.Requisition_Line_Id = x_req_line_id
1306: );
1307:
1308: ELSE

Line 1562: FROM po_requisition_lines_all reqline, TABLE(X_entity_id) entity

1558: -- Linked_PO _Count would be 1 for all req lines, as Info and Option lines
1559: -- can be linked to Award only by Autocreate and its one to one mapping.
1560: SELECT requisition_line_id, linked_po_count
1561: BULK COLLECT INTO l_unlinked_reqLine_ids, l_unlinked_po_count
1562: FROM po_requisition_lines_all reqline, TABLE(X_entity_id) entity
1563: WHERE (reqline.clm_info_flag = 'Y' OR reqline.clm_option_indicator = 'O'
1564: OR reqLine.par_draft_id IS NOT NULL) --To process PAR lines without any distribution
1565: -- Dod - Exclude Info Funded Slins
1566: AND NOT EXISTS ( SELECT 1 FROM po_req_distributions_all prd

Line 1699: UPDATE po_requisition_lines_all

1695: -- If atleast on requisition line found whioh is linked to deleted entity.
1696: IF l_unlinked_reqLine_ids.Count > 0 THEN
1697: -- Update the linked po count by decrementing it.
1698: FORALL i IN 1..l_unlinked_reqLine_ids.Count
1699: UPDATE po_requisition_lines_all
1700: SET linked_po_count = linked_po_count - l_unlinked_po_count(i),
1701: last_update_date = SYSDATE,
1702: last_updated_by = FND_GLOBAL.USER_ID,
1703: last_update_login = FND_GLOBAL.LOGIN_ID

Line 1717: UPDATE po_requisition_lines_all

1713:
1714: -- Nullify the po-Line-id and line_location_id for the all the requisition lines
1715: -- whose linked_po_count is zero.
1716: FORALL i IN 1..l_unlinked_reqLine_ids.Count
1717: UPDATE po_requisition_lines_all
1718: SET po_line_id = NULL, line_location_id = NULL
1719: WHERE requisition_line_id = l_unlinked_reqLine_ids(i)
1720: AND linked_po_count = 0;
1721:

Line 1739: FROM po_requisition_lines_all rl, TABLE(l_unlinked_reqLine_ids) entity

1735: -- Priced Clins those got deleted from Ditribution tab
1736: BEGIN
1737: SELECT requisition_line_id
1738: BULK COLLECT INTO l_pclin_ids
1739: FROM po_requisition_lines_all rl, TABLE(l_unlinked_reqLine_ids) entity
1740: WHERE rl.requisition_line_id = entity.column_value
1741: AND group_line_id IS NULL
1742: AND Nvl(clm_info_flag,'N') <> 'Y' AND Nvl(clm_option_indicator,'X') <> 'O';
1743:

Line 1750: UPDATE po_requisition_lines_all

1746: END;
1747: -- Nullify the po-Line-id, line_location_id and linked_po_count to 0 for the all Slins,
1748: -- if deleted/unlinked line is Priced Clin from distribution tab
1749: FORALL i IN 1..l_pclin_ids.Count
1750: UPDATE po_requisition_lines_all
1751: SET po_line_id = NULL, line_location_id = NULL , linked_po_count = 0
1752: WHERE group_line_id = l_pclin_ids(i);
1753:
1754: x_progress := 50;

Line 1777: FROM po_requisition_lines_all rl, TABLE(l_infofunded_slin_grp_ids) entity

1773: BEGIN
1774: -- Check if all the Info Funded Slins are unlinked for the group_line_id
1775: SELECT group_line_id
1776: BULK COLLECT INTO l_infofd_group_line_ids
1777: FROM po_requisition_lines_all rl, TABLE(l_infofunded_slin_grp_ids) entity
1778: WHERE group_line_id = entity.column_value
1779: GROUP BY group_line_id HAVING Sum(Nvl(linked_po_count,0)) = 0;
1780:
1781: EXCEPTION WHEN No_Data_Found THEN

Line 1795: UPDATE po_requisition_lines_all

1791: END IF;
1792:
1793: -- Update the Priced Clin of Info Funded Slins, if all Slins unlinked
1794: FORALL i IN 1..l_infofd_group_line_ids.Count
1795: UPDATE po_requisition_lines_all
1796: SET po_line_id = NULL, line_location_id = NULL , linked_po_count = 0
1797: WHERE requisition_line_id = l_infofd_group_line_ids(i);
1798:
1799: -- Enter Priced Clin of Info funded slins into GT table, for sending all reqs in structure back to pool

Line 1817: FROM po_requisition_lines_all l

1813: group_line_id,
1814: clm_base_line_num,
1815: linked_po_count,
1816: requisition_line_id
1817: FROM po_requisition_lines_all l
1818: WHERE requisition_line_id = l_infofd_group_line_ids(i);
1819:
1820: x_progress := 80;
1821: IF g_fnd_debug = 'Y' THEN

Line 1851: FROM po_requisition_lines_all l

1847: group_line_id,
1848: clm_base_line_num,
1849: linked_po_count,
1850: requisition_line_id
1851: FROM po_requisition_lines_all l
1852: WHERE requisition_line_id = l_unlinked_reqLine_ids(i)
1853: AND (
1854: (group_line_id IS NULL ) -- All Clins (AutoCreate and SoftLinked)
1855: OR

Line 1915: FROM po_requisition_lines_all

1911: FORALL i IN 1..p_reqLine_ids.Count
1912: UPDATE po_lines_draft_all
1913: SET DRAFT_LINE_STATUS = 'COMPLETED'
1914: WHERE (po_line_id, draft_id) IN ( SELECT par_line_id, par_draft_id
1915: FROM po_requisition_lines_all
1916: WHERE requisition_line_id = p_reqLine_ids(i)
1917: AND requisition_header_id = p_reqHeader_ids(i)
1918: AND assignment_number IS NULL
1919: );

Line 1925: FROM po_requisition_lines_all

1921: FORALL i IN 1..p_reqLine_ids.Count
1922: UPDATE po_lines_draft_all
1923: SET DRAFT_LINE_STATUS = 'ASSIGNED'
1924: WHERE (po_line_id, draft_id) IN ( SELECT par_line_id, par_draft_id
1925: FROM po_requisition_lines_all
1926: WHERE requisition_line_id = p_reqLine_ids(i)
1927: AND requisition_header_id = p_reqHeader_ids(i)
1928: AND assignment_number IS NOT NULL
1929: );

Line 1986: FROM po_requisition_lines_all r,

1982: LOOP
1983: INSERT INTO po_session_gt gt3 (index_char1, index_num1, index_num2, num1, num2, num3, num10)
1984:
1985: SELECT 'UNLINKED_REQUISITIONS', r.requisition_line_id, r.requisition_header_id, r.group_line_id, r.clm_base_line_num, r.linked_po_count, num10
1986: FROM po_requisition_lines_all r,
1987: po_session_gt gt
1988: WHERE
1989: r.requisition_header_id = gt.index_num2
1990: AND gt.index_char1 = 'UNLINKED_REQUISITIONS'

Line 2038: UPDATE po_requisition_lines_all

2034:
2035: -- Update the reqs_in_pool_flag for the entire Clin-Slin structure if it dont have any
2036: -- POs linked. Above l_eligible_reqLine_ids will give us the list.
2037: FORALL i IN 1..l_eligible_reqLine_ids.Count
2038: UPDATE po_requisition_lines_all
2039: SET reqs_in_pool_flag = 'Y',
2040: linked_po_count = NULL,
2041: last_update_date = SYSDATE,
2042: last_updated_by = FND_GLOBAL.USER_ID,