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.CSP_REPAIR_PO_PVT dependencies on PO_HEADERS_ALL

Line 70: CURSOR PO_HEADERS_ALL(l_requisition_line_id NUMBER) IS

66: WHERE PRH.SEGMENT1 = l_requisition_number AND
67: PRL.REQUISITION_LINE_ID = l_requisition_line_id AND
68: PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID;
69:
70: CURSOR PO_HEADERS_ALL(l_requisition_line_id NUMBER) IS
71: SELECT POH.po_header_id, POH.segment1, POH.AUTHORIZATION_STATUS, POH.closed_code,
72: PLL.line_location_id, PLL.po_line_id
73: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
74: WHERE PRL.REQUISITION_LINE_ID = l_requisition_line_id AND

Line 73: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH

69:
70: CURSOR PO_HEADERS_ALL(l_requisition_line_id NUMBER) IS
71: SELECT POH.po_header_id, POH.segment1, POH.AUTHORIZATION_STATUS, POH.closed_code,
72: PLL.line_location_id, PLL.po_line_id
73: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
74: WHERE PRL.REQUISITION_LINE_ID = l_requisition_line_id AND
75: PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
76: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
77:

Line 119: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH

115: CURSOR PO_REQ_RECEIVED_QTY(l_requisition_line_id NUMBER) IS
116: SELECT PLL.quantity_received, PRL.closed_code,
117: POH.po_header_id, POH.segment1, POH.AUTHORIZATION_STATUS, -- POH.closed_code,
118: PLL.line_location_id, PLL.po_line_id
119: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
120: WHERE PRL.REQUISITION_LINE_ID = l_requisition_line_id AND
121: PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
122: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
123:

Line 233: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH

229: CURSOR PO_REQ_RECEIVED_QTY(l_requisition_line_id NUMBER) IS
230: SELECT PLL.quantity_received, PRL.closed_code,
231: POH.po_header_id, POH.segment1, POH.AUTHORIZATION_STATUS, -- POH.closed_code,
232: PLL.line_location_id, PLL.po_line_id
233: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
234: WHERE PRL.REQUISITION_LINE_ID = l_requisition_line_id AND
235: PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
236: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
237: */

Line 341: If record is created in PO_HEADERS_ALL table

337:
338: ---- Start Step:3 ----
339:
340: /** For all the repair_po with status '3'
341: If record is created in PO_HEADERS_ALL table
342: and CLOSED_CODE (or) AUTHORIZATION_STATUS is not 'APPROVED' then update the status = 4.
343: Else if CLOSED_CODE (or) AUTHORIZATION_STATUS = 'APPROVED' then update the status = 5.
344: **/
345:

Line 350: FOR PO_HEADERS_ALL_rec IN PO_HEADERS_ALL(CSP_REPAIR_PO_HEADERS_rec.REQUISITION_LINE_ID)

346: SAVEPOINT RUN_REPAIR_EXECUTION_PVT;
347:
348: FOR CSP_REPAIR_PO_HEADERS_rec IN C_CSP_REPAIR_PO_HEADERS(3)
349: LOOP
350: FOR PO_HEADERS_ALL_rec IN PO_HEADERS_ALL(CSP_REPAIR_PO_HEADERS_rec.REQUISITION_LINE_ID)
351: LOOP
352: If NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'OPEN'
353: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'OPEN' then
354: UPDATE CSP_REPAIR_PO_HEADERS

Line 352: If NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'OPEN'

348: FOR CSP_REPAIR_PO_HEADERS_rec IN C_CSP_REPAIR_PO_HEADERS(3)
349: LOOP
350: FOR PO_HEADERS_ALL_rec IN PO_HEADERS_ALL(CSP_REPAIR_PO_HEADERS_rec.REQUISITION_LINE_ID)
351: LOOP
352: If NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'OPEN'
353: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'OPEN' then
354: UPDATE CSP_REPAIR_PO_HEADERS
355: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
356: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 4

Line 353: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'OPEN' then

349: LOOP
350: FOR PO_HEADERS_ALL_rec IN PO_HEADERS_ALL(CSP_REPAIR_PO_HEADERS_rec.REQUISITION_LINE_ID)
351: LOOP
352: If NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'OPEN'
353: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'OPEN' then
354: UPDATE CSP_REPAIR_PO_HEADERS
355: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
356: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 4
357: WHERE CURRENT OF C_CSP_REPAIR_PO_HEADERS;

Line 355: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,

351: LOOP
352: If NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'OPEN'
353: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'OPEN' then
354: UPDATE CSP_REPAIR_PO_HEADERS
355: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
356: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 4
357: WHERE CURRENT OF C_CSP_REPAIR_PO_HEADERS;
358: Elsif NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'APPROVED'
359: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'APPROVED' then

Line 356: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 4

352: If NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'OPEN'
353: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'OPEN' then
354: UPDATE CSP_REPAIR_PO_HEADERS
355: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
356: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 4
357: WHERE CURRENT OF C_CSP_REPAIR_PO_HEADERS;
358: Elsif NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'APPROVED'
359: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'APPROVED' then
360: UPDATE CSP_REPAIR_PO_HEADERS

Line 358: Elsif NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'APPROVED'

354: UPDATE CSP_REPAIR_PO_HEADERS
355: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
356: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 4
357: WHERE CURRENT OF C_CSP_REPAIR_PO_HEADERS;
358: Elsif NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'APPROVED'
359: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'APPROVED' then
360: UPDATE CSP_REPAIR_PO_HEADERS
361: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
362: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 5

Line 359: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'APPROVED' then

355: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
356: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 4
357: WHERE CURRENT OF C_CSP_REPAIR_PO_HEADERS;
358: Elsif NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'APPROVED'
359: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'APPROVED' then
360: UPDATE CSP_REPAIR_PO_HEADERS
361: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
362: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 5
363: WHERE CURRENT OF C_CSP_REPAIR_PO_HEADERS;

Line 361: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,

357: WHERE CURRENT OF C_CSP_REPAIR_PO_HEADERS;
358: Elsif NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'APPROVED'
359: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'APPROVED' then
360: UPDATE CSP_REPAIR_PO_HEADERS
361: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
362: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 5
363: WHERE CURRENT OF C_CSP_REPAIR_PO_HEADERS;
364: End if;
365: END LOOP;

Line 362: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 5

358: Elsif NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'APPROVED'
359: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'APPROVED' then
360: UPDATE CSP_REPAIR_PO_HEADERS
361: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
362: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 5
363: WHERE CURRENT OF C_CSP_REPAIR_PO_HEADERS;
364: End if;
365: END LOOP;
366: END LOOP;

Line 375: If record is created in PO_HEADERS_ALL table

371:
372: ---- Start Step:4 ----
373:
374: /** For all the repair_po with status '4'
375: If record is created in PO_HEADERS_ALL table
376: and CLOSED_CODE (or) AUTHORIZATION_STATUS = 'APPROVED' then update the status = 5.
377: **/
378:
379: SAVEPOINT RUN_REPAIR_EXECUTION_PVT;

Line 383: FOR PO_HEADERS_ALL_rec IN PO_HEADERS_ALL(CSP_REPAIR_PO_HEADERS_rec.REQUISITION_LINE_ID)

379: SAVEPOINT RUN_REPAIR_EXECUTION_PVT;
380:
381: FOR CSP_REPAIR_PO_HEADERS_rec IN C_CSP_REPAIR_PO_HEADERS(4)
382: LOOP
383: FOR PO_HEADERS_ALL_rec IN PO_HEADERS_ALL(CSP_REPAIR_PO_HEADERS_rec.REQUISITION_LINE_ID)
384: LOOP
385: If NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'APPROVED'
386: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'APPROVED' then
387: UPDATE CSP_REPAIR_PO_HEADERS

Line 385: If NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'APPROVED'

381: FOR CSP_REPAIR_PO_HEADERS_rec IN C_CSP_REPAIR_PO_HEADERS(4)
382: LOOP
383: FOR PO_HEADERS_ALL_rec IN PO_HEADERS_ALL(CSP_REPAIR_PO_HEADERS_rec.REQUISITION_LINE_ID)
384: LOOP
385: If NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'APPROVED'
386: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'APPROVED' then
387: UPDATE CSP_REPAIR_PO_HEADERS
388: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
389: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 5

Line 386: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'APPROVED' then

382: LOOP
383: FOR PO_HEADERS_ALL_rec IN PO_HEADERS_ALL(CSP_REPAIR_PO_HEADERS_rec.REQUISITION_LINE_ID)
384: LOOP
385: If NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'APPROVED'
386: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'APPROVED' then
387: UPDATE CSP_REPAIR_PO_HEADERS
388: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
389: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 5
390: WHERE CURRENT OF C_CSP_REPAIR_PO_HEADERS;

Line 388: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,

384: LOOP
385: If NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'APPROVED'
386: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'APPROVED' then
387: UPDATE CSP_REPAIR_PO_HEADERS
388: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
389: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 5
390: WHERE CURRENT OF C_CSP_REPAIR_PO_HEADERS;
391: End if;
392: END LOOP;

Line 389: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 5

385: If NVL(PO_HEADERS_ALL_rec.CLOSED_CODE,'OPEN') = 'APPROVED'
386: OR NVL(PO_HEADERS_ALL_rec.AUTHORIZATION_STATUS,'OPEN') = 'APPROVED' then
387: UPDATE CSP_REPAIR_PO_HEADERS
388: SET PURCHASE_ORDER_HEADER_ID = PO_HEADERS_ALL_rec.PO_HEADER_ID,
389: PO_NUMBER = PO_HEADERS_ALL_rec.SEGMENT1, STATUS = 5
390: WHERE CURRENT OF C_CSP_REPAIR_PO_HEADERS;
391: End if;
392: END LOOP;
393: END LOOP;

Line 401: i.e Record is created in PO_HEADERS_ALL table and CLOSED_CODE (or) AUTHORIZATION_STATUS = 'APPROVED'

397: ---- End Step:4 ----
398:
399: ---- Start Step:5 ----
400: /** For all the repair_po with status '5'
401: i.e Record is created in PO_HEADERS_ALL table and CLOSED_CODE (or) AUTHORIZATION_STATUS = 'APPROVED'
402: If no internal order is created and REPAIR_PROGRAM <> 'PRE-POSITIONING' then
403: create an internal order and cancel the existing reservation.
404: **/
405:

Line 649: PO_HEADERS_ALL POH

645: lc_org_id
646: FROM PO_REQUISITION_LINES_ALL PRL,
647: PO_LINE_LOCATIONS_ALL PLL,
648: PO_LINES_ALL POL,
649: PO_HEADERS_ALL POH
650: WHERE PRL.REQUISITION_LINE_ID =
651: CSP_REPAIR_PO_HEADERS_rec.REQUISITION_LINE_ID
652: AND PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
653: AND PLL.PO_LINE_ID = POL.PO_LINE_ID

Line 1084: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH

1080: nvl(IO_QTY_RECEIVED_CHECK_REC.QUANTITY_RECEIVED,0) > 0 THEN
1081:
1082: SELECT PLL.quantity_received, PRL.closed_code, POH.po_header_id, PRL.Quantity, PLL.line_location_id, PLL.po_line_id,poh.org_id
1083: into L_quantity_received, L_closed_code, LC_po_header_id, L_PO_Quantity, L_line_location_id, L_po_line_id,lc_org_id
1084: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
1085: WHERE PRL.REQUISITION_LINE_ID = CSP_REPAIR_PO_HEADERS_rec.REQUISITION_LINE_ID AND
1086: PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1087: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
1088:

Line 1644: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH

1640: CURSOR PO_REQ_RECEIVED_QTY(l_requisition_line_id NUMBER) IS
1641: SELECT PLL.quantity_received, PRL.closed_code,
1642: POH.po_header_id, POH.segment1, POH.AUTHORIZATION_STATUS, -- POH.closed_code,
1643: PLL.line_location_id, PLL.po_line_id
1644: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
1645: WHERE PRL.REQUISITION_LINE_ID = l_requisition_line_id AND
1646: PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1647: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
1648: */

Line 2003: --select org_id into l_po_operating_unit from po_headers_all where PO_HEADER_ID= l_po_header_id;

1999: WHERE REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID
2000: AND inventory_item_id = L_SCRAP_ADJUST_ITEM_ID;
2001:
2002: End if;
2003: --select org_id into l_po_operating_unit from po_headers_all where PO_HEADER_ID= l_po_header_id;
2004: --change_operating_unit( l_po_operating_unit );
2005: --fnd_global.apps_initialize(7985, 52124, 201);
2006:
2007: SELECT PLL.quantity_received, PRL.closed_code, POH.po_header_id, PRL.Quantity, PLL.line_location_id, PLL.po_line_id, poh.org_id

Line 2009: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH

2005: --fnd_global.apps_initialize(7985, 52124, 201);
2006:
2007: SELECT PLL.quantity_received, PRL.closed_code, POH.po_header_id, PRL.Quantity, PLL.line_location_id, PLL.po_line_id, poh.org_id
2008: into L_quantity_received, L_closed_code, LC_po_header_id, L_PO_Quantity, L_line_location_id, L_po_line_id, l_org_id
2009: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
2010: WHERE PRL.REQUISITION_LINE_ID = CSP_REPAIR_PO_SCRAP_rec.REQUISITION_LINE_ID AND
2011: PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
2012: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
2013:

Line 2021: FROM PO_LINES_ALL PL, PO_HEADERS_ALL POH

2017:
2018: /*
2019: SELECT PL.line_num
2020: into L_line_num
2021: FROM PO_LINES_ALL PL, PO_HEADERS_ALL POH
2022: WHERE PL.PO_LINE_ID = L_po_line_id AND
2023: PL.PO_HEADER_ID = POH.PO_HEADER_ID;
2024: */
2025: