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_RELGEN_PKG dependencies on PO_RELEASES

Line 240: UPDATE po_releases_all por

236: --
237:
238: /*Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all */
239:
240: UPDATE po_releases_all por
241: SET por.authorization_status = 'INCOMPLETE',
242: por.approved_flag = 'N'
243: WHERE por.po_release_id = x_po_release_id;
244:

Line 355: UPDATE po_releases_all por

351: ELSIF (l_check_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
352:
353: -- 354: -- LCM submission check fails>
355: UPDATE po_releases_all por
356: SET por.authorization_status = 'INCOMPLETE',
357: por.approved_flag = 'N',
358: por.approved_date = NULL
359: WHERE por.po_release_id = x_po_release_id;

Line 513: UPDATE po_releases_all por

509: -- as the tax calculation has failed
510: --
511: /*Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all */
512:
513: UPDATE po_releases_all por
514: SET por.authorization_status = 'INCOMPLETE',
515: por.approved_flag = 'N'
516: WHERE por.po_release_id = x_po_release_id;
517:

Line 612: UPDATE po_releases_all por

608: ELSIF (l_check_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
609:
610: -- 611: -- LCM submission check fails>
612: UPDATE po_releases_all por
613: SET por.authorization_status = 'INCOMPLETE',
614: por.approved_flag = 'N',
615: por.approved_date = NULL
616: WHERE por.po_release_id = x_po_release_id;

Line 727: SELECT PO_RELEASES_S.NEXTVAL

723: ELSE
724: x_authorization_status := 'INCOMPLETE';
725: END IF;
726:
727: SELECT PO_RELEASES_S.NEXTVAL
728: INTO x_po_release_id
729: FROM SYS.DUAL;
730:
731: /* Bug 1834138. pchintal. Code for calculating the shipment number.

Line 743: FROM PO_RELEASES

739: END IF;
740:
741: SELECT NVL(MAX(RELEASE_NUM) +1,1)
742: INTO x_release_num
743: FROM PO_RELEASES
744: WHERE PO_HEADER_ID = req_line.blanket_po_header_id;
745:
746: /* Bug 6454219 Added code to fetch shipping_control from the BPA.
747: Same would be inserted into po_releases_all table */

Line 747: Same would be inserted into po_releases_all table */

743: FROM PO_RELEASES
744: WHERE PO_HEADER_ID = req_line.blanket_po_header_id;
745:
746: /* Bug 6454219 Added code to fetch shipping_control from the BPA.
747: Same would be inserted into po_releases_all table */
748: SELECT PAY_ON_CODE, SHIPPING_CONTROL
749: INTO x_pay_on_code, x_shipping_control
750: FROM PO_HEADERS
751: WHERE PO_HEADER_ID = req_line.blanket_po_header_id;

Line 765: INSERT INTO PO_RELEASES

761: );
762: END IF;
763: -- Bug 3570793 END
764:
765: INSERT INTO PO_RELEASES
766: (PO_RELEASE_ID,
767: LAST_UPDATE_DATE,
768: LAST_UPDATED_BY,
769: PO_HEADER_ID,

Line 2052: FROM PO_RELEASES

2048: DECODE(APPROVED_FLAG,
2049: 'R','REQUIRES_REAPPROVAL',
2050: 'F','FAILED_APPROVAL',
2051: 'NEVER_APPROVED'))
2052: FROM PO_RELEASES
2053: WHERE NVL(CANCEL_FLAG,'N') = 'N'
2054: AND NVL(APPROVED_FLAG,'N') <> 'Y'
2055: AND PO_RELEASE_ID = x_po_release_id; */
2056: null;

Line 2293: po_releases por,

2289:
2290: SELECT nvl(sum(poll.quantity * poll.price_override),0)
2291: INTO total_release_amount
2292: FROM po_line_locations poll,
2293: po_releases por,
2294: po_headers poh
2295: WHERE poh.po_header_id = x_old_po_header_id
2296: AND poll.po_header_id = poh.po_header_id
2297: AND poll.shipment_type = 'BLANKET'

Line 2946: FROM PO_LINES POL,PO_RELEASES POR,PO_LINE_LOCATIONS PLL

2942: g_linemsg||g_delim||POL.line_num||
2943: g_delim||l_textline||g_delim||POL.min_release_amount,1,240)
2944: --Bug 12553671 end
2945: BULK COLLECT INTO l_error_messages
2946: FROM PO_LINES POL,PO_RELEASES POR,PO_LINE_LOCATIONS PLL
2947: , PO_HEADERS POH --Bug 12553671, Added table
2948: WHERE POH.po_header_id = POL.po_header_id --Bug 12553671
2949: AND PLL.po_release_id = POR.po_release_id
2950: AND PLL.po_release_id = x_po_release_id

Line 3130: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,

3126: g_linemsg||g_delim||p_req_line_num||
3127: g_delim||l_textline,1,240)
3128: BULK COLLECT INTO l_error_messages
3129: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3130: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3131: FINANCIALS_SYSTEM_PARAMETERS FSP
3132: WHERE POR.po_release_id = x_po_release_id
3133: AND POR.po_header_id = POH.po_header_id
3134: AND POR.po_header_id = POL.po_header_id

Line 3204: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,

3200: g_linemsg||g_delim||p_req_line_num||
3201: g_delim||l_textline,1,240)
3202: BULK COLLECT INTO l_error_messages
3203: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3204: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3205: FINANCIALS_SYSTEM_PARAMETERS FSP
3206: WHERE POR.po_release_id = x_po_release_id
3207: AND POR.po_header_id = POH.po_header_id
3208: AND POR.po_header_id = POL.po_header_id

Line 3317: FROM PO_RELEASES_ALL POR,

3313: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_SHIP_INV_MATCH_NE_R');
3314:
3315: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||l_textline,1,240)
3316: BULK COLLECT INTO l_error_messages
3317: FROM PO_RELEASES_ALL POR,
3318: PO_LINE_LOCATIONS_ALL PLL
3319: WHERE POR.po_release_id = PLL.po_release_id
3320: AND POR.po_release_id = x_po_release_id
3321: AND Nvl(PLL.LCM_FLAG,'N') = 'Y'

Line 3344: FROM PO_RELEASES_GT POR,

3340:
3341: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||g_distmsg||g_delim||
3342: POD.distribution_num||g_delim||l_textline, 1,240)
3343: BULK COLLECT INTO l_error_messages
3344: FROM PO_RELEASES_GT POR,
3345: PO_LINE_LOCATIONS_GT PLL,
3346: PO_DISTRIBUTIONS_GT POD
3347: WHERE POR.po_release_id = POD.po_release_id
3348: AND POD.line_location_id = PLL.line_location_id