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 6576: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;

6572: p_manufacturer OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE,
6573: p_lead_time OUT NOCOPY PO_ATTRIBUTE_VALUES.lead_time%TYPE
6574: )
6575: IS
6576: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;
6577: BEGIN
6578: get_item_attributes_values(p_inventory_item_id, p_manufacturer_part_num ,p_manufacturer, p_lead_time, l_manufacturer_id);
6579: END get_item_attributes_values;
6580:

Line 6611: p_manufacturer_id OUT NOCOPY po_requisition_lines_All.MANUFACTURER_ID%TYPE

6607: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6608: p_manufacturer_part_num OUT NOCOPY PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE,
6609: p_manufacturer OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE,
6610: p_lead_time OUT NOCOPY PO_ATTRIBUTE_VALUES.lead_time%TYPE,
6611: p_manufacturer_id OUT NOCOPY po_requisition_lines_All.MANUFACTURER_ID%TYPE
6612: )
6613: IS
6614: d_mod CONSTANT VARCHAR2(100) := D_get_item_attributes_values;
6615: l_progress VARCHAR2(4);