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 98: l_base_unit_price PO_REQUISITION_LINES.base_unit_price%TYPE;

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

Line 894: l_src_blanket_header_id po_requisition_lines.blanket_po_header_id%TYPE;

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

Line 895: l_src_blanket_line_num po_requisition_lines.blanket_po_line_num%TYPE;

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

Line 896: l_quantity po_requisition_lines.quantity%TYPE;

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

Line 897: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;

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

Line 898: l_currency_code po_requisition_lines.currency_code%TYPE;

894: l_src_blanket_header_id po_requisition_lines.blanket_po_header_id%TYPE;
895: l_src_blanket_line_num po_requisition_lines.blanket_po_line_num%TYPE;
896: l_quantity po_requisition_lines.quantity%TYPE;
897: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;
898: l_currency_code po_requisition_lines.currency_code%TYPE;
899: l_rate_type po_requisition_lines.rate_type%TYPE;
900: l_need_by_date po_requisition_lines.need_by_date%TYPE;
901: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
902: l_base_price_out po_requisition_lines.unit_price%TYPE;

Line 899: l_rate_type po_requisition_lines.rate_type%TYPE;

895: l_src_blanket_line_num po_requisition_lines.blanket_po_line_num%TYPE;
896: l_quantity po_requisition_lines.quantity%TYPE;
897: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;
898: l_currency_code po_requisition_lines.currency_code%TYPE;
899: l_rate_type po_requisition_lines.rate_type%TYPE;
900: l_need_by_date po_requisition_lines.need_by_date%TYPE;
901: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
902: l_base_price_out po_requisition_lines.unit_price%TYPE;
903: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;

Line 900: l_need_by_date po_requisition_lines.need_by_date%TYPE;

896: l_quantity po_requisition_lines.quantity%TYPE;
897: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;
898: l_currency_code po_requisition_lines.currency_code%TYPE;
899: l_rate_type po_requisition_lines.rate_type%TYPE;
900: l_need_by_date po_requisition_lines.need_by_date%TYPE;
901: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
902: l_base_price_out po_requisition_lines.unit_price%TYPE;
903: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;
904: l_discount_out NUMBER;

Line 901: l_destination_org po_requisition_lines.destination_organization_id%TYPE;

897: l_deliver_to_location po_requisition_lines.deliver_to_location_id%TYPE;
898: l_currency_code po_requisition_lines.currency_code%TYPE;
899: l_rate_type po_requisition_lines.rate_type%TYPE;
900: l_need_by_date po_requisition_lines.need_by_date%TYPE;
901: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
902: l_base_price_out po_requisition_lines.unit_price%TYPE;
903: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;
904: l_discount_out NUMBER;
905: l_currency_code_out po_requisition_lines.currency_code%TYPE;

Line 902: l_base_price_out po_requisition_lines.unit_price%TYPE;

898: l_currency_code po_requisition_lines.currency_code%TYPE;
899: l_rate_type po_requisition_lines.rate_type%TYPE;
900: l_need_by_date po_requisition_lines.need_by_date%TYPE;
901: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
902: l_base_price_out po_requisition_lines.unit_price%TYPE;
903: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;
904: l_discount_out NUMBER;
905: l_currency_code_out po_requisition_lines.currency_code%TYPE;
906: l_rate_type_out po_requisition_lines.rate_type%TYPE;

Line 903: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;

899: l_rate_type po_requisition_lines.rate_type%TYPE;
900: l_need_by_date po_requisition_lines.need_by_date%TYPE;
901: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
902: l_base_price_out po_requisition_lines.unit_price%TYPE;
903: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;
904: l_discount_out NUMBER;
905: l_currency_code_out po_requisition_lines.currency_code%TYPE;
906: l_rate_type_out po_requisition_lines.rate_type%TYPE;
907: l_rate_date_out po_requisition_lines.rate_date%TYPE;

Line 905: l_currency_code_out po_requisition_lines.currency_code%TYPE;

901: l_destination_org po_requisition_lines.destination_organization_id%TYPE;
902: l_base_price_out po_requisition_lines.unit_price%TYPE;
903: l_currency_price_out po_requisition_lines.currency_unit_price%TYPE;
904: l_discount_out NUMBER;
905: l_currency_code_out po_requisition_lines.currency_code%TYPE;
906: l_rate_type_out po_requisition_lines.rate_type%TYPE;
907: l_rate_date_out po_requisition_lines.rate_date%TYPE;
908: l_rate_out po_requisition_lines.rate%TYPE;
909: l_uom po_requisitions_interface.unit_of_measure%TYPE;

Line 906: l_rate_type_out po_requisition_lines.rate_type%TYPE;

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

Line 907: l_rate_date_out po_requisition_lines.rate_date%TYPE;

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

Line 908: l_rate_out po_requisition_lines.rate%TYPE;

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

Line 915: l_requisition_header_id po_requisition_lines.requisition_header_id%TYPE;

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

Line 916: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;

912:
913: --
914: l_org_id po_requisitions_interface.org_id%TYPE;
915: l_requisition_header_id po_requisition_lines.requisition_header_id%TYPE;
916: l_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;
917: l_creation_date po_requisitions_interface.creation_date%TYPE;
918: l_item_id po_requisitions_interface.item_id%TYPE;
919: l_item_revision po_requisitions_interface.item_revision%TYPE;
920: l_category_id po_requisitions_interface.category_id%TYPE;

Line 927: l_base_unit_price_out po_requisition_lines.base_unit_price%TYPE;

923: l_suggested_vendor_id po_requisitions_interface.suggested_vendor_id%TYPE;
924: l_suggested_vendor_site_id po_requisitions_interface.suggested_vendor_site_id%TYPE;
925: -- Bug 3343892
926: l_base_unit_price po_requisitions_interface.base_unit_price%TYPE;
927: l_base_unit_price_out po_requisition_lines.base_unit_price%TYPE;
928: --
929:
930: CURSOR req_lines IS
931: SELECT pri.rowid, pri.autosource_doc_header_id, pri.autosource_doc_line_num,