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

Line 27: l_order_id oe_order_lines_all.header_id%TYPE; --Added for MACD Enhancement

23:
24: l_message_id number;
25: l_transactable_flag mtl_system_items_b.mtl_transactions_enabled_flag%TYPE; --bug6140021
26: l_org_id number;
27: l_order_id oe_order_lines_all.header_id%TYPE; --Added for MACD Enhancement
28: l_vld_organization_id number;
29: l_inventory_item_id number;
30: l_line_category_code oe_order_lines_all.line_category_code%TYPE;
31: l_shippable_flag mtl_system_items_b.shippable_item_flag%TYPE;

Line 30: l_line_category_code oe_order_lines_all.line_category_code%TYPE;

26: l_org_id number;
27: l_order_id oe_order_lines_all.header_id%TYPE; --Added for MACD Enhancement
28: l_vld_organization_id number;
29: l_inventory_item_id number;
30: l_line_category_code oe_order_lines_all.line_category_code%TYPE;
31: l_shippable_flag mtl_system_items_b.shippable_item_flag%TYPE;
32: l_ordered_item varchar2(80);
33: l_item_type_code varchar2(30);
34: l_fulfilled_qty number;

Line 69: l_config_header_id oe_order_lines_all.config_header_id%type;--Added for MACD Enhancement

65: l_end number;
66: l_num_threads number;
67: l_max_processes number;
68: l_om_session_key csi_utility_grp.config_session_key; --Added for MACD Enhancement
69: l_config_header_id oe_order_lines_all.config_header_id%type;--Added for MACD Enhancement
70: l_config_rev_nbr oe_order_lines_all.config_rev_nbr%type; --Added for MACD Enhancement
71: l_configuration_id oe_order_lines_all.configuration_id%type;--Added for MACD Enhancement
72: l_macd_processing boolean := FALSE; --Added for MACD Enhancement
73:

Line 70: l_config_rev_nbr oe_order_lines_all.config_rev_nbr%type; --Added for MACD Enhancement

66: l_num_threads number;
67: l_max_processes number;
68: l_om_session_key csi_utility_grp.config_session_key; --Added for MACD Enhancement
69: l_config_header_id oe_order_lines_all.config_header_id%type;--Added for MACD Enhancement
70: l_config_rev_nbr oe_order_lines_all.config_rev_nbr%type; --Added for MACD Enhancement
71: l_configuration_id oe_order_lines_all.configuration_id%type;--Added for MACD Enhancement
72: l_macd_processing boolean := FALSE; --Added for MACD Enhancement
73:
74: BEGIN

Line 71: l_configuration_id oe_order_lines_all.configuration_id%type;--Added for MACD Enhancement

67: l_max_processes number;
68: l_om_session_key csi_utility_grp.config_session_key; --Added for MACD Enhancement
69: l_config_header_id oe_order_lines_all.config_header_id%type;--Added for MACD Enhancement
70: l_config_rev_nbr oe_order_lines_all.config_rev_nbr%type; --Added for MACD Enhancement
71: l_configuration_id oe_order_lines_all.configuration_id%type;--Added for MACD Enhancement
72: l_macd_processing boolean := FALSE; --Added for MACD Enhancement
73:
74: BEGIN
75:

Line 119: FROM oe_order_lines_all

115: l_config_header_id,--Added for MACD Enhancement
116: l_config_rev_nbr, --Added for MACD Enhancement
117: l_configuration_id,--Added for MACD Enhancement
118: l_ato_line_id
119: FROM oe_order_lines_all
120: WHERE line_id = p_order_line_id;
121:
122: debug(' inventory_item_id : '||l_inventory_item_id);
123: