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_ATTRIBUTE_VALUES_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 130: FROM PON_BACKING_REQUISITIONS PB, PO_REQUISITION_LINES_ALL PRL

126: SELECT PAIP.line_number,
127: PAV.*
128: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,
129: ( SELECT PB.auction_header_id, PB.line_number, blanket_po_header_id, blanket_po_line_num
130: FROM PON_BACKING_REQUISITIONS PB, PO_REQUISITION_LINES_ALL PRL
131: WHERE PB.auction_header_id = p_auction_header_id
132: AND PB.requisition_header_id = PRL.requisition_header_id
133: AND PB.requisition_line_id = PRL.requisition_line_id
134: AND PRL.blanket_po_header_id IS NOT NULL

Line 157: FROM PON_BACKING_REQUISITIONS PB, PO_REQUISITION_LINES_ALL PRL

153: SELECT PAIP.line_number,
154: PAVT.*
155: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,
156: ( SELECT PB.auction_header_id, PB.line_number, blanket_po_header_id, blanket_po_line_num
157: FROM PON_BACKING_REQUISITIONS PB, PO_REQUISITION_LINES_ALL PRL
158: WHERE PB.auction_header_id = p_auction_header_id
159: AND PB.requisition_header_id = PRL.requisition_header_id
160: AND PB.requisition_line_id = PRL.requisition_line_id
161: AND PRL.blanket_po_header_id IS NOT NULL

Line 6443: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;

6439: p_manufacturer OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE,
6440: p_lead_time OUT NOCOPY PO_ATTRIBUTE_VALUES.lead_time%TYPE
6441: )
6442: IS
6443: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;
6444: BEGIN
6445: get_item_attributes_values(p_inventory_item_id, p_manufacturer_part_num ,p_manufacturer, p_lead_time, l_manufacturer_id);
6446: END get_item_attributes_values;
6447:

Line 6478: p_manufacturer_id OUT NOCOPY po_requisition_lines_All.MANUFACTURER_ID%TYPE

6474: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6475: p_manufacturer_part_num OUT NOCOPY PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE,
6476: p_manufacturer OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE,
6477: p_lead_time OUT NOCOPY PO_ATTRIBUTE_VALUES.lead_time%TYPE,
6478: p_manufacturer_id OUT NOCOPY po_requisition_lines_All.MANUFACTURER_ID%TYPE
6479: )
6480: IS
6481: d_mod CONSTANT VARCHAR2(100) := D_get_item_attributes_values;
6482: l_progress VARCHAR2(4);