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.OE_INBOUND_INT dependencies on OE_ORDER_LINES_ALL

Line 5075: line_id oe_order_lines_all.line_id%TYPE,

5071:
5072: l_action_request_tbl OE_ORDER_PUB_REQUEST_TBL_TYPE;
5073:
5074: TYPE config_process_rec_type IS RECORD (
5075: line_id oe_order_lines_all.line_id%TYPE,
5076: config_header_id oe_order_lines_all.config_header_id%TYPE,
5077: inventory_item_id oe_order_lines_all.inventory_item_id%TYPE,
5078: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
5079: unit_selling_price oe_order_lines_all.unit_selling_price%TYPE,

Line 5076: config_header_id oe_order_lines_all.config_header_id%TYPE,

5072: l_action_request_tbl OE_ORDER_PUB_REQUEST_TBL_TYPE;
5073:
5074: TYPE config_process_rec_type IS RECORD (
5075: line_id oe_order_lines_all.line_id%TYPE,
5076: config_header_id oe_order_lines_all.config_header_id%TYPE,
5077: inventory_item_id oe_order_lines_all.inventory_item_id%TYPE,
5078: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
5079: unit_selling_price oe_order_lines_all.unit_selling_price%TYPE,
5080: unit_list_price oe_order_lines_all.unit_list_price%TYPE

Line 5077: inventory_item_id oe_order_lines_all.inventory_item_id%TYPE,

5073:
5074: TYPE config_process_rec_type IS RECORD (
5075: line_id oe_order_lines_all.line_id%TYPE,
5076: config_header_id oe_order_lines_all.config_header_id%TYPE,
5077: inventory_item_id oe_order_lines_all.inventory_item_id%TYPE,
5078: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
5079: unit_selling_price oe_order_lines_all.unit_selling_price%TYPE,
5080: unit_list_price oe_order_lines_all.unit_list_price%TYPE
5081: );

Line 5078: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,

5074: TYPE config_process_rec_type IS RECORD (
5075: line_id oe_order_lines_all.line_id%TYPE,
5076: config_header_id oe_order_lines_all.config_header_id%TYPE,
5077: inventory_item_id oe_order_lines_all.inventory_item_id%TYPE,
5078: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
5079: unit_selling_price oe_order_lines_all.unit_selling_price%TYPE,
5080: unit_list_price oe_order_lines_all.unit_list_price%TYPE
5081: );
5082:

Line 5079: unit_selling_price oe_order_lines_all.unit_selling_price%TYPE,

5075: line_id oe_order_lines_all.line_id%TYPE,
5076: config_header_id oe_order_lines_all.config_header_id%TYPE,
5077: inventory_item_id oe_order_lines_all.inventory_item_id%TYPE,
5078: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
5079: unit_selling_price oe_order_lines_all.unit_selling_price%TYPE,
5080: unit_list_price oe_order_lines_all.unit_list_price%TYPE
5081: );
5082:
5083: TYPE config_process_tab_type IS TABLE OF config_process_rec_type

Line 5080: unit_list_price oe_order_lines_all.unit_list_price%TYPE

5076: config_header_id oe_order_lines_all.config_header_id%TYPE,
5077: inventory_item_id oe_order_lines_all.inventory_item_id%TYPE,
5078: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
5079: unit_selling_price oe_order_lines_all.unit_selling_price%TYPE,
5080: unit_list_price oe_order_lines_all.unit_list_price%TYPE
5081: );
5082:
5083: TYPE config_process_tab_type IS TABLE OF config_process_rec_type
5084: INDEX BY PLS_INTEGER;

Line 5544: l_flow_stat oe_order_lines_all.flow_status_code%TYPE;

5540: --
5541: -- Step 3B: Load the flow_status_code for each line from the database.
5542: --
5543: DECLARE
5544: l_flow_stat oe_order_lines_all.flow_status_code%TYPE;
5545: l_item_type oe_order_lines_all.item_type_code%TYPE;
5546: l_config_rev_nbr oe_order_lines_all.config_rev_nbr%TYPE;
5547:
5548: TYPE number_table_type IS TABLE OF NUMBER;

Line 5545: l_item_type oe_order_lines_all.item_type_code%TYPE;

5541: -- Step 3B: Load the flow_status_code for each line from the database.
5542: --
5543: DECLARE
5544: l_flow_stat oe_order_lines_all.flow_status_code%TYPE;
5545: l_item_type oe_order_lines_all.item_type_code%TYPE;
5546: l_config_rev_nbr oe_order_lines_all.config_rev_nbr%TYPE;
5547:
5548: TYPE number_table_type IS TABLE OF NUMBER;
5549: l_model_line_tab number_table_type;

Line 5546: l_config_rev_nbr oe_order_lines_all.config_rev_nbr%TYPE;

5542: --
5543: DECLARE
5544: l_flow_stat oe_order_lines_all.flow_status_code%TYPE;
5545: l_item_type oe_order_lines_all.item_type_code%TYPE;
5546: l_config_rev_nbr oe_order_lines_all.config_rev_nbr%TYPE;
5547:
5548: TYPE number_table_type IS TABLE OF NUMBER;
5549: l_model_line_tab number_table_type;
5550: l_count NUMBER := 0;

Line 5554: FROM oe_order_lines_all

5550: l_count NUMBER := 0;
5551:
5552: CURSOR config_child_lines(p_top_model_line_id IN NUMBER) IS
5553: SELECT line_id
5554: FROM oe_order_lines_all
5555: WHERE top_model_line_id = p_top_model_line_id
5556: AND line_id <> p_top_model_line_id
5557: AND flow_status_code <> 'CANCELLED'
5558: ;

Line 5572: FROM oe_order_lines_all l

5568: LOOP
5569: oe_debug_pub.ADD('line_id in loop..... ' || x_line_tbl(idx).line_id);
5570: SELECT flow_status_code, item_type_code, config_rev_nbr
5571: INTO l_flow_stat, l_item_type, l_config_rev_nbr
5572: FROM oe_order_lines_all l
5573: WHERE l.line_id = x_line_tbl(idx).line_id;
5574:
5575: x_line_tbl(idx).flow_status_code := l_flow_stat;
5576: x_line_tbl(idx).config_rev_nbr := l_config_rev_nbr;