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_LINES

Line 859: l_po_line_id po_lines_all.po_line_id%TYPE := null;

855:
856: /* */
857: l_quantity po_requisition_lines_all.quantity%TYPE := null;
858: l_price_break_type varchar2(1) := null;
859: l_po_line_id po_lines_all.po_line_id%TYPE := null;
860: l_cumulative_flag boolean;
861: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;
862: l_need_by_date po_requisition_lines_all.need_by_date%TYPE := null;
863: /* */

Line 871: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950

867: l_po_promised_def_prf VARCHAR2(1) := fnd_profile.value('PO_NEED_BY_PROMISE_DEFAULTING');
868: --
869:
870: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
871: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
872: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
873: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
874:
875: --

Line 872: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950

868: --
869:
870: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
871: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
872: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
873: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
874:
875: --
876: l_return_status VARCHAR2(1);

Line 873: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950

869:
870: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
871: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
872: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
873: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
874:
875: --
876: l_return_status VARCHAR2(1);
877: l_msg_count NUMBER;

Line 1046: from po_lines_all

1042: into l_price_break_type,
1043: l_value_basis,
1044: l_matching_basis,
1045: l_unit_meas_lookup_code
1046: from po_lines_all
1047: where po_line_id = l_po_line_id;
1048: EXCEPTION
1049: when others then
1050: null;

Line 1280: /* Bug# 3104460 - Do not update PO_LINES.QUANTITY with released amount

1276:
1277: /* bug 2994264 : need to round off the quantity as indicated in the above fix.
1278: The above fix indicates the rounding, but due to some reason,
1279: it was missed, hence doing it as a part of this fix. */
1280: /* Bug# 3104460 - Do not update PO_LINES.QUANTITY with released amount
1281: UPDATE SQL deleted */
1282:
1283: /* Bug 947709
1284: ** Adding code to copy attachments from Requisition

Line 1703: from po_lines pol,

1699:
1700: IF (req_line.blanket_po_line_id is not NULL) THEN
1701: select nvl(rcv_controls.receipt_required_flag,plt.receiving_flag)
1702: into rcv_controls.receipt_required_flag
1703: from po_lines pol,
1704: po_line_types plt
1705: where pol.po_line_id = req_line.blanket_po_line_id
1706: and pol.line_type_id = plt.line_type_id;
1707: END IF;

Line 1715: from po_lines pol,

1711: rcv_controls.receipt_close_tolerance is null) THEN
1712:
1713: select nvl(rcv_controls.receipt_close_tolerance, plt.receive_close_tolerance)
1714: into rcv_controls.receipt_close_tolerance
1715: from po_lines pol,
1716: po_line_types plt
1717: where pol.po_line_id = req_line.blanket_po_line_id
1718: and pol.line_type_id = plt.line_type_id;
1719: END IF;

Line 1961: po_lines pol

1957: pod.destination_subinventory,
1958: 'Y'
1959: from po_distributions pod,
1960: po_line_locations poll,
1961: po_lines pol
1962: where poll.line_location_id = x_line_location_id
1963: and nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1964: and nvl(poll.closed_code, 'OPEN') <> 'CLOSED'
1965: and nvl(poll.closed_code, 'OPEN') <> 'CLOSED FOR RECEIVING'

Line 2155: FROM PO_LINES

2151: /* Get the price break type CUMULATIVE or NON CUMULATIVE */
2152:
2153: SELECT PRICE_BREAK_LOOKUP_CODE
2154: INTO x_price_break_type
2155: FROM PO_LINES
2156: WHERE PO_LINE_ID = req_line.blanket_po_line_id;
2157:
2158: /* Get the price break quantity based on the price break type */
2159: /* This is done by calculating the released amount if required */

Line 2202: FROM PO_LINES

2198: /* Get the blanket line price */
2199:
2200: SELECT UNIT_PRICE
2201: INTO x_po_line_price
2202: FROM PO_LINES
2203: WHERE PO_LINE_ID = req_line.blanket_po_line_id;
2204:
2205: /* Determine the final price for the item shipment */
2206:

Line 2456: TYPE unit_of_measure IS TABLE of PO_LINES.unit_meas_lookup_code%TYPE;

2452: l_enforce_price_tolerance po_system_parameters.enforce_price_change_allowance%TYPE;
2453: l_enforce_price_amount po_system_parameters.enforce_price_change_amount%TYPE;
2454: l_amount_tolerance po_system_parameters.price_change_amount%TYPE;
2455:
2456: TYPE unit_of_measure IS TABLE of PO_LINES.unit_meas_lookup_code%TYPE;
2457: TYPE NumTab IS TABLE of NUMBER;
2458: l_ship_price_in_base_curr NumTab;
2459: l_ship_unit_of_measure unit_of_measure;
2460: l_ship_num NumTab;

Line 2504: PO_LINES POL,

2500: nvl(POL.item_id,0) item_id,
2501: nvl( POLL.line_location_id,0) line_loc_id
2502: FROM PO_LINE_LOCATIONS POLL,
2503: PO_LINE_TYPES PLT,
2504: PO_LINES POL,
2505: PO_DISTRIBUTIONS POD
2506: WHERE POLL.po_line_id = POL.po_line_id
2507: AND POLL.line_location_id = POD.line_location_id
2508: AND POLL.po_release_id = p_document_id

Line 2524: PO_LINES POL

2520: min(POL.line_num),
2521: min(POLL.shipment_num)
2522: FROM PO_REQUISITION_LINES PRL,
2523: PO_LINE_LOCATIONS POLL,
2524: PO_LINES POL
2525: WHERE PRL.line_location_id = POLL.line_location_id
2526: AND POLL.line_location_id = p_line_location_id
2527: AND PRL.unit_price >= 0
2528: AND POLL.po_line_id = POL.po_line_id

Line 2539: PO_LINES POL,

2535: min(POL.line_num),
2536: min(POLL.shipment_num)
2537: FROM PO_REQUISITION_LINES PRL,
2538: PO_LINE_LOCATIONS POLL,
2539: PO_LINES POL,
2540: PO_DISTRIBUTIONS PD,
2541: PO_REQ_DISTRIBUTIONS PRD
2542: WHERE POLL.line_location_id = p_line_location_id
2543: AND POLL.po_line_id = POL.po_line_id

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

2911: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
2912: g_linemsg||g_delim||p_req_line_num||
2913: g_delim||l_textline||g_delim||POL.min_release_amount,1,240)
2914: BULK COLLECT INTO l_error_messages
2915: FROM PO_LINES POL,PO_RELEASES POR,PO_LINE_LOCATIONS PLL
2916: WHERE PLL.po_release_id = POR.po_release_id
2917: AND PLL.po_release_id = x_po_release_id
2918: AND POL.po_line_id = PLL.po_line_id
2919: AND POL.min_release_amount is not null

Line 2970: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL, PO_LINES POL

2966: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_GL_ENC_PER');
2967: SELECT substr(l_textline,1,240),
2968: POD.po_distribution_id
2969: BULK COLLECT INTO l_error_messages, l_dist_id
2970: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL, PO_LINES POL
2971: WHERE POD.line_location_id = PLL.line_location_id
2972: AND PLL.po_release_id = x_po_release_id
2973: AND POL.po_line_id = PLL.po_line_id
2974: AND nvl(POD.encumbered_flag,'N') = 'N'

Line 3029: PO_LINES POL, MTL_UOM_CLASSES_TL MTL1,

3025: MTL1.uom_class||' , '||MTL2.uom_class,1,240),
3026: POLL.line_location_id
3027: BULK COLLECT INTO l_error_messages, l_line_location_id
3028: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINE_LOCATIONS POLL,
3029: PO_LINES POL, MTL_UOM_CLASSES_TL MTL1,
3030: MTL_UOM_CLASSES_TL MTL2
3031: WHERE MOU.inventory_item_id = POL.item_id
3032: AND (NVL(MOU.disable_date, TRUNC(SYSDATE)) + 1) < TRUNC(SYSDATE)
3033: AND POL.po_line_id = POLL.po_line_id

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

3072: g_linemsg||g_delim||p_req_line_num||
3073: g_delim||l_textline,1,240)
3074: BULK COLLECT INTO l_error_messages
3075: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3076: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3077: FINANCIALS_SYSTEM_PARAMETERS FSP
3078: WHERE POR.po_release_id = x_po_release_id
3079: AND POR.po_header_id = POH.po_header_id
3080: AND POR.po_header_id = POL.po_header_id

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

3146: g_linemsg||g_delim||p_req_line_num||
3147: g_delim||l_textline,1,240)
3148: BULK COLLECT INTO l_error_messages
3149: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3150: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3151: FINANCIALS_SYSTEM_PARAMETERS FSP
3152: WHERE POR.po_release_id = x_po_release_id
3153: AND POR.po_header_id = POH.po_header_id
3154: AND POR.po_header_id = POL.po_header_id