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_HEADERS

Line 750: FROM PO_HEADERS

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;
752:
753: -- Bug 3570793 START
754: IF (g_debug_stmt) THEN

Line 1093: FROM PO_HEADERS POH, FND_CURRENCIES FC

1089: x_country_of_origin_code);
1090:
1091: SELECT FC.EXTENDED_PRECISION
1092: INTO x_ext_precision
1093: FROM PO_HEADERS POH, FND_CURRENCIES FC
1094: WHERE POH.PO_HEADER_ID = req_line.blanket_po_header_id
1095: AND POH.CURRENCY_CODE = FC.CURRENCY_CODE;
1096:
1097: --

Line 1569: PO_HEADERS PH,

1565: PLL.shipment_type,
1566: PH.Org_Id --
1567: FROM PO_REQ_DISTRIBUTIONS PRD,
1568: PO_REQUISITION_LINES PRL,
1569: PO_HEADERS PH,
1570: PO_LINE_LOCATIONS PLL
1571: WHERE PRD.REQUISITION_LINE_ID = req_line.requisition_line_id
1572: AND PRL.REQUISITION_LINE_ID = req_line.requisition_line_id
1573: AND PH.PO_HEADER_ID = req_line.blanket_po_header_id

Line 2294: po_headers poh

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'
2298: AND poll.po_release_id = por.po_release_id

Line 2305: FROM po_headers poh

2301: AND nvl(poll.cancel_flag,'N') = 'N';
2302:
2303: SELECT nvl(poh.min_release_amount,0)
2304: INTO min_release_amount
2305: FROM po_headers poh
2306: WHERE po_header_id = x_old_po_header_id;
2307:
2308: SELECT nvl(poh.amount_limit,-1),segment1
2309: INTO max_release_amount,x_po_num

Line 2310: FROM po_headers poh

2306: WHERE po_header_id = x_old_po_header_id;
2307:
2308: SELECT nvl(poh.amount_limit,-1),segment1
2309: INTO max_release_amount,x_po_num
2310: FROM po_headers poh
2311: WHERE po_header_id = x_old_po_header_id;
2312:
2313:
2314: IF (release_amount < min_release_amount)

Line 2632: FROM FND_CURRENCIES FND, PO_HEADERS POH,

2628: --checking for tolerance
2629: BEGIN
2630: SELECT round(l_ship_price_in_base_curr(shipment_line),nvl(FND.extended_precision,5))
2631: INTO l_ship_price_ext_precn
2632: FROM FND_CURRENCIES FND, PO_HEADERS POH,
2633: PO_LINE_LOCATIONS POLL
2634: WHERE POH.po_header_id = POLL.po_header_id
2635: AND POH.currency_code = FND.currency_code
2636: AND POLL.line_location_id = l_line_location_id(shipment_line);

Line 2892: l_vendor_id PO_HEADERS.vendor_id%TYPE;

2888: -- If the profile option 'Enable Transaction Code' is set to Yes, then
2889: -- it is a federal instance, and we need to check vendor site registration
2890: -- status when necessary
2891: l_federal_instance VARCHAR2(1);
2892: l_vendor_id PO_HEADERS.vendor_id%TYPE;
2893: l_vendor_site_id PO_HEADERS.vendor_site_id%TYPE;
2894: l_valid_registration BOOLEAN := FALSE;
2895: --
2896: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;

Line 2893: l_vendor_site_id PO_HEADERS.vendor_site_id%TYPE;

2889: -- it is a federal instance, and we need to check vendor site registration
2890: -- status when necessary
2891: l_federal_instance VARCHAR2(1);
2892: l_vendor_id PO_HEADERS.vendor_id%TYPE;
2893: l_vendor_site_id PO_HEADERS.vendor_site_id%TYPE;
2894: l_valid_registration BOOLEAN := FALSE;
2895: --
2896: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
2897: l_purch_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;

Line 2947: , PO_HEADERS POH --Bug 12553671, Added table

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
2951: AND POL.po_line_id = PLL.po_line_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 3280: FROM po_headers_all

3276: -- SQL Why: need to check vendor site registration status below
3277: BEGIN
3278: SELECT vendor_id, vendor_site_id
3279: INTO l_vendor_id, l_vendor_site_id
3280: FROM po_headers_all
3281: WHERE po_header_id = p_po_header_id;
3282: EXCEPTION
3283: WHEN OTHERS THEN
3284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3625: p_vendor_id IN po_headers_all.vendor_id%TYPE,

3621: */
3622: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,
3623: p_category_id IN po_requisition_lines_all.category_id%TYPE,
3624: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,
3625: p_vendor_id IN po_headers_all.vendor_id%TYPE,
3626: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE )
3627: return number
3628: as
3629:

Line 3626: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE )

3622: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,
3623: p_category_id IN po_requisition_lines_all.category_id%TYPE,
3624: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,
3625: p_vendor_id IN po_headers_all.vendor_id%TYPE,
3626: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE )
3627: return number
3628: as
3629:
3630: l_progress VARCHAR2(3) := '000';