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 865: l_po_line_id po_lines_all.po_line_id%TYPE := null;

861:
862: /* */
863: l_quantity po_requisition_lines_all.quantity%TYPE := null;
864: l_price_break_type varchar2(1) := null;
865: l_po_line_id po_lines_all.po_line_id%TYPE := null;
866: l_cumulative_flag boolean;
867: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;
868: l_need_by_date po_requisition_lines_all.need_by_date%TYPE := null;
869: /* */

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

873: l_po_promised_def_prf VARCHAR2(1) := fnd_profile.value('PO_NEED_BY_PROMISE_DEFAULTING');
874: --
875:
876: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
877: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
878: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
879: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
880:
881: --

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

874: --
875:
876: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
877: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
878: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
879: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
880:
881: --
882: l_return_status VARCHAR2(1);

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

875:
876: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
877: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
878: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
879: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
880:
881: --
882: l_return_status VARCHAR2(1);
883: l_msg_count NUMBER;

Line 1052: from po_lines_all

1048: into l_price_break_type,
1049: l_value_basis,
1050: l_matching_basis,
1051: l_unit_meas_lookup_code
1052: from po_lines_all
1053: where po_line_id = l_po_line_id;
1054: EXCEPTION
1055: when others then
1056: null;

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

1285:
1286: /* bug 2994264 : need to round off the quantity as indicated in the above fix.
1287: The above fix indicates the rounding, but due to some reason,
1288: it was missed, hence doing it as a part of this fix. */
1289: /* Bug# 3104460 - Do not update PO_LINES.QUANTITY with released amount
1290: UPDATE SQL deleted */
1291:
1292: /* Bug 947709
1293: ** Adding code to copy attachments from Requisition

Line 1719: from po_lines pol,

1715:
1716: IF (req_line.blanket_po_line_id is not NULL) THEN
1717: select nvl(rcv_controls.receipt_required_flag,plt.receiving_flag)
1718: into rcv_controls.receipt_required_flag
1719: from po_lines pol,
1720: po_line_types plt
1721: where pol.po_line_id = req_line.blanket_po_line_id
1722: and pol.line_type_id = plt.line_type_id;
1723: END IF;

Line 1731: from po_lines pol,

1727: rcv_controls.receipt_close_tolerance is null) THEN
1728:
1729: select nvl(rcv_controls.receipt_close_tolerance, plt.receive_close_tolerance)
1730: into rcv_controls.receipt_close_tolerance
1731: from po_lines pol,
1732: po_line_types plt
1733: where pol.po_line_id = req_line.blanket_po_line_id
1734: and pol.line_type_id = plt.line_type_id;
1735: END IF;

Line 1986: po_lines pol

1982: pod.destination_subinventory,
1983: 'Y'
1984: from po_distributions pod,
1985: po_line_locations poll,
1986: po_lines pol
1987: where poll.line_location_id = x_line_location_id
1988: and nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1989: and nvl(poll.closed_code, 'OPEN') <> 'CLOSED'
1990: and nvl(poll.closed_code, 'OPEN') <> 'CLOSED FOR RECEIVING'

Line 2180: FROM PO_LINES

2176: /* Get the price break type CUMULATIVE or NON CUMULATIVE */
2177:
2178: SELECT PRICE_BREAK_LOOKUP_CODE
2179: INTO x_price_break_type
2180: FROM PO_LINES
2181: WHERE PO_LINE_ID = req_line.blanket_po_line_id;
2182:
2183: /* Get the price break quantity based on the price break type */
2184: /* This is done by calculating the released amount if required */

Line 2227: FROM PO_LINES

2223: /* Get the blanket line price */
2224:
2225: SELECT UNIT_PRICE
2226: INTO x_po_line_price
2227: FROM PO_LINES
2228: WHERE PO_LINE_ID = req_line.blanket_po_line_id;
2229:
2230: /* Determine the final price for the item shipment */
2231:

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

2477: l_enforce_price_tolerance po_system_parameters.enforce_price_change_allowance%TYPE;
2478: l_enforce_price_amount po_system_parameters.enforce_price_change_amount%TYPE;
2479: l_amount_tolerance po_system_parameters.price_change_amount%TYPE;
2480:
2481: TYPE unit_of_measure IS TABLE of PO_LINES.unit_meas_lookup_code%TYPE;
2482: TYPE NumTab IS TABLE of NUMBER;
2483: l_ship_price_in_base_curr NumTab;
2484: l_ship_unit_of_measure unit_of_measure;
2485: l_ship_num NumTab;

Line 2529: PO_LINES POL,

2525: nvl(POL.item_id,0) item_id,
2526: nvl( POLL.line_location_id,0) line_loc_id
2527: FROM PO_LINE_LOCATIONS POLL,
2528: PO_LINE_TYPES PLT,
2529: PO_LINES POL,
2530: PO_DISTRIBUTIONS POD
2531: WHERE POLL.po_line_id = POL.po_line_id
2532: AND POLL.line_location_id = POD.line_location_id
2533: AND POLL.po_release_id = p_document_id

Line 2549: PO_LINES POL

2545: min(POL.line_num),
2546: min(POLL.shipment_num)
2547: FROM PO_REQUISITION_LINES PRL,
2548: PO_LINE_LOCATIONS POLL,
2549: PO_LINES POL
2550: WHERE PRL.line_location_id = POLL.line_location_id
2551: AND POLL.line_location_id = p_line_location_id
2552: AND PRL.unit_price >= 0
2553: AND POLL.po_line_id = POL.po_line_id

Line 2564: PO_LINES POL,

2560: min(POL.line_num),
2561: min(POLL.shipment_num)
2562: FROM PO_REQUISITION_LINES PRL,
2563: PO_LINE_LOCATIONS POLL,
2564: PO_LINES POL,
2565: PO_DISTRIBUTIONS PD,
2566: PO_REQ_DISTRIBUTIONS PRD
2567: WHERE POLL.line_location_id = p_line_location_id
2568: AND POLL.po_line_id = POL.po_line_id

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 3024: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL, PO_LINES POL

3020: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_GL_ENC_PER');
3021: SELECT substr(l_textline,1,240),
3022: POD.po_distribution_id
3023: BULK COLLECT INTO l_error_messages, l_dist_id
3024: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL, PO_LINES POL
3025: WHERE POD.line_location_id = PLL.line_location_id
3026: AND PLL.po_release_id = x_po_release_id
3027: AND POL.po_line_id = PLL.po_line_id
3028: AND nvl(POD.encumbered_flag,'N') = 'N'

Line 3083: PO_LINES POL, MTL_UOM_CLASSES_TL MTL1,

3079: MTL1.uom_class||' , '||MTL2.uom_class,1,240),
3080: POLL.line_location_id
3081: BULK COLLECT INTO l_error_messages, l_line_location_id
3082: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINE_LOCATIONS POLL,
3083: PO_LINES POL, MTL_UOM_CLASSES_TL MTL1,
3084: MTL_UOM_CLASSES_TL MTL2
3085: WHERE MOU.inventory_item_id = POL.item_id
3086: AND (NVL(MOU.disable_date, TRUNC(SYSDATE)) + 1) < TRUNC(SYSDATE)
3087: AND POL.po_line_id = POLL.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