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_PRICE_BREAK_GRP dependencies on PO_REQUISITION_LINES

Line 101: l_base_unit_price PO_REQUISITION_LINES.base_unit_price%TYPE;

97: x_rate OUT NOCOPY NUMBER,
98: x_price_break_id OUT NOCOPY NUMBER --
99: ) is
100: --
101: l_base_unit_price PO_REQUISITION_LINES.base_unit_price%TYPE;
102: --
103: Begin
104:
105: get_price_break

Line 898: l_src_blanket_header_id po_requisition_lines.blanket_po_header_id%TYPE;

894: Procedure Reqimport_Set_Break_Price(
895: p_request_id IN po_requisitions_interface.request_id%TYPE
896: ) IS
897: l_rowid VARCHAR2(250) := '';
898: l_src_blanket_header_id po_requisition_lines.blanket_po_header_id%TYPE;
899: l_src_blanket_line_num po_requisition_lines.blanket_po_line_num%TYPE;
900: l_quantity po_requisition_lines.quantity%TYPE;
901: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;
902: l_currency_code po_requisition_lines.currency_code%TYPE;

Line 899: l_src_blanket_line_num po_requisition_lines.blanket_po_line_num%TYPE;

895: p_request_id IN po_requisitions_interface.request_id%TYPE
896: ) IS
897: l_rowid VARCHAR2(250) := '';
898: l_src_blanket_header_id po_requisition_lines.blanket_po_header_id%TYPE;
899: l_src_blanket_line_num po_requisition_lines.blanket_po_line_num%TYPE;
900: l_quantity po_requisition_lines.quantity%TYPE;
901: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;
902: l_currency_code po_requisition_lines.currency_code%TYPE;
903: l_rate_type po_requisition_lines.rate_type%TYPE;

Line 900: l_quantity po_requisition_lines.quantity%TYPE;

896: ) IS
897: l_rowid VARCHAR2(250) := '';
898: l_src_blanket_header_id po_requisition_lines.blanket_po_header_id%TYPE;
899: l_src_blanket_line_num po_requisition_lines.blanket_po_line_num%TYPE;
900: l_quantity po_requisition_lines.quantity%TYPE;
901: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;
902: l_currency_code po_requisition_lines.currency_code%TYPE;
903: l_rate_type po_requisition_lines.rate_type%TYPE;
904: l_need_by_date po_requisition_lines.need_by_date%TYPE;

Line 901: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;

897: l_rowid VARCHAR2(250) := '';
898: l_src_blanket_header_id po_requisition_lines.blanket_po_header_id%TYPE;
899: l_src_blanket_line_num po_requisition_lines.blanket_po_line_num%TYPE;
900: l_quantity po_requisition_lines.quantity%TYPE;
901: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;
902: l_currency_code po_requisition_lines.currency_code%TYPE;
903: l_rate_type po_requisition_lines.rate_type%TYPE;
904: l_need_by_date po_requisition_lines.need_by_date%TYPE;
905: l_destination_org po_requisition_lines.destination_organization_id%TYPE;

Line 902: l_currency_code po_requisition_lines.currency_code%TYPE;

898: l_src_blanket_header_id po_requisition_lines.blanket_po_header_id%TYPE;
899: l_src_blanket_line_num po_requisition_lines.blanket_po_line_num%TYPE;
900: l_quantity po_requisition_lines.quantity%TYPE;
901: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;
902: l_currency_code po_requisition_lines.currency_code%TYPE;
903: l_rate_type po_requisition_lines.rate_type%TYPE;
904: l_need_by_date po_requisition_lines.need_by_date%TYPE;
905: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
906: l_base_price_out po_requisition_lines.unit_price%TYPE;

Line 903: l_rate_type po_requisition_lines.rate_type%TYPE;

899: l_src_blanket_line_num po_requisition_lines.blanket_po_line_num%TYPE;
900: l_quantity po_requisition_lines.quantity%TYPE;
901: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;
902: l_currency_code po_requisition_lines.currency_code%TYPE;
903: l_rate_type po_requisition_lines.rate_type%TYPE;
904: l_need_by_date po_requisition_lines.need_by_date%TYPE;
905: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
906: l_base_price_out po_requisition_lines.unit_price%TYPE;
907: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;

Line 904: l_need_by_date po_requisition_lines.need_by_date%TYPE;

900: l_quantity po_requisition_lines.quantity%TYPE;
901: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;
902: l_currency_code po_requisition_lines.currency_code%TYPE;
903: l_rate_type po_requisition_lines.rate_type%TYPE;
904: l_need_by_date po_requisition_lines.need_by_date%TYPE;
905: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
906: l_base_price_out po_requisition_lines.unit_price%TYPE;
907: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;
908: l_discount_out NUMBER;

Line 905: l_destination_org po_requisition_lines.destination_organization_id%TYPE;

901: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;
902: l_currency_code po_requisition_lines.currency_code%TYPE;
903: l_rate_type po_requisition_lines.rate_type%TYPE;
904: l_need_by_date po_requisition_lines.need_by_date%TYPE;
905: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
906: l_base_price_out po_requisition_lines.unit_price%TYPE;
907: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;
908: l_discount_out NUMBER;
909: l_currency_code_out po_requisition_lines.currency_code%TYPE;

Line 906: l_base_price_out po_requisition_lines.unit_price%TYPE;

902: l_currency_code po_requisition_lines.currency_code%TYPE;
903: l_rate_type po_requisition_lines.rate_type%TYPE;
904: l_need_by_date po_requisition_lines.need_by_date%TYPE;
905: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
906: l_base_price_out po_requisition_lines.unit_price%TYPE;
907: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;
908: l_discount_out NUMBER;
909: l_currency_code_out po_requisition_lines.currency_code%TYPE;
910: l_rate_type_out po_requisition_lines.rate_type%TYPE;

Line 907: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;

903: l_rate_type po_requisition_lines.rate_type%TYPE;
904: l_need_by_date po_requisition_lines.need_by_date%TYPE;
905: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
906: l_base_price_out po_requisition_lines.unit_price%TYPE;
907: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;
908: l_discount_out NUMBER;
909: l_currency_code_out po_requisition_lines.currency_code%TYPE;
910: l_rate_type_out po_requisition_lines.rate_type%TYPE;
911: l_rate_date_out po_requisition_lines.rate_date%TYPE;

Line 909: l_currency_code_out po_requisition_lines.currency_code%TYPE;

905: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
906: l_base_price_out po_requisition_lines.unit_price%TYPE;
907: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;
908: l_discount_out NUMBER;
909: l_currency_code_out po_requisition_lines.currency_code%TYPE;
910: l_rate_type_out po_requisition_lines.rate_type%TYPE;
911: l_rate_date_out po_requisition_lines.rate_date%TYPE;
912: l_rate_out po_requisition_lines.rate%TYPE;
913: l_uom po_requisitions_interface.unit_of_measure%TYPE;

Line 910: l_rate_type_out po_requisition_lines.rate_type%TYPE;

906: l_base_price_out po_requisition_lines.unit_price%TYPE;
907: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;
908: l_discount_out NUMBER;
909: l_currency_code_out po_requisition_lines.currency_code%TYPE;
910: l_rate_type_out po_requisition_lines.rate_type%TYPE;
911: l_rate_date_out po_requisition_lines.rate_date%TYPE;
912: l_rate_out po_requisition_lines.rate%TYPE;
913: l_uom po_requisitions_interface.unit_of_measure%TYPE;
914: l_price_break_id po_line_locations_all.line_location_id%TYPE; --

Line 911: l_rate_date_out po_requisition_lines.rate_date%TYPE;

907: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;
908: l_discount_out NUMBER;
909: l_currency_code_out po_requisition_lines.currency_code%TYPE;
910: l_rate_type_out po_requisition_lines.rate_type%TYPE;
911: l_rate_date_out po_requisition_lines.rate_date%TYPE;
912: l_rate_out po_requisition_lines.rate%TYPE;
913: l_uom po_requisitions_interface.unit_of_measure%TYPE;
914: l_price_break_id po_line_locations_all.line_location_id%TYPE; --
915: l_progress VARCHAR2(3) := NULL;

Line 912: l_rate_out po_requisition_lines.rate%TYPE;

908: l_discount_out NUMBER;
909: l_currency_code_out po_requisition_lines.currency_code%TYPE;
910: l_rate_type_out po_requisition_lines.rate_type%TYPE;
911: l_rate_date_out po_requisition_lines.rate_date%TYPE;
912: l_rate_out po_requisition_lines.rate%TYPE;
913: l_uom po_requisitions_interface.unit_of_measure%TYPE;
914: l_price_break_id po_line_locations_all.line_location_id%TYPE; --
915: l_progress VARCHAR2(3) := NULL;
916:

Line 919: l_requisition_header_id po_requisition_lines.requisition_header_id%TYPE;

915: l_progress VARCHAR2(3) := NULL;
916:
917: --
918: l_org_id po_requisitions_interface.org_id%TYPE;
919: l_requisition_header_id po_requisition_lines.requisition_header_id%TYPE;
920: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;
921: l_creation_date po_requisitions_interface.creation_date%TYPE;
922: l_item_id po_requisitions_interface.item_id%TYPE;
923: l_item_revision po_requisitions_interface.item_revision%TYPE;

Line 920: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;

916:
917: --
918: l_org_id po_requisitions_interface.org_id%TYPE;
919: l_requisition_header_id po_requisition_lines.requisition_header_id%TYPE;
920: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;
921: l_creation_date po_requisitions_interface.creation_date%TYPE;
922: l_item_id po_requisitions_interface.item_id%TYPE;
923: l_item_revision po_requisitions_interface.item_revision%TYPE;
924: l_category_id po_requisitions_interface.category_id%TYPE;

Line 931: l_base_unit_price_out po_requisition_lines.base_unit_price%TYPE;

927: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
928: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;
929: -- Bug 3343892
930: l_base_unit_price po_requisitions_interface.base_unit_price%TYPE;
931: l_base_unit_price_out po_requisition_lines.base_unit_price%TYPE;
932: --
933:
934: CURSOR req_lines IS
935: SELECT pri.rowid, pri.autosource_doc_header_id, pri.autosource_doc_line_num,