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 25: FROM CS_ESTIMATE_DETAILS,OE_ORDER_LINES_ALL

21: l_return_status BOOLEAN := FALSE;
22: l_dummy_order_line_id NUMBER;
23: BEGIN
24: SELECT ORDER_LINE_ID INTO l_dummy_order_line_id
25: FROM CS_ESTIMATE_DETAILS,OE_ORDER_LINES_ALL
26: WHERE CS_ESTIMATE_DETAILS.incident_ID = OE_ORDER_LINES_ALL.source_document_ID
27: AND CS_ESTIMATE_DETAILS.SOURCE_CODE = 'SD'
28: AND OE_ORDER_LINES_ALL.source_document_type_id = 7
29: AND oe_order_lines_all.line_id = p_order_line_id;

Line 26: WHERE CS_ESTIMATE_DETAILS.incident_ID = OE_ORDER_LINES_ALL.source_document_ID

22: l_dummy_order_line_id NUMBER;
23: BEGIN
24: SELECT ORDER_LINE_ID INTO l_dummy_order_line_id
25: FROM CS_ESTIMATE_DETAILS,OE_ORDER_LINES_ALL
26: WHERE CS_ESTIMATE_DETAILS.incident_ID = OE_ORDER_LINES_ALL.source_document_ID
27: AND CS_ESTIMATE_DETAILS.SOURCE_CODE = 'SD'
28: AND OE_ORDER_LINES_ALL.source_document_type_id = 7
29: AND oe_order_lines_all.line_id = p_order_line_id;
30:

Line 28: AND OE_ORDER_LINES_ALL.source_document_type_id = 7

24: SELECT ORDER_LINE_ID INTO l_dummy_order_line_id
25: FROM CS_ESTIMATE_DETAILS,OE_ORDER_LINES_ALL
26: WHERE CS_ESTIMATE_DETAILS.incident_ID = OE_ORDER_LINES_ALL.source_document_ID
27: AND CS_ESTIMATE_DETAILS.SOURCE_CODE = 'SD'
28: AND OE_ORDER_LINES_ALL.source_document_type_id = 7
29: AND oe_order_lines_all.line_id = p_order_line_id;
30:
31: l_return_status := TRUE;
32: -- Return TRUE as the order line is debrief order

Line 29: AND oe_order_lines_all.line_id = p_order_line_id;

25: FROM CS_ESTIMATE_DETAILS,OE_ORDER_LINES_ALL
26: WHERE CS_ESTIMATE_DETAILS.incident_ID = OE_ORDER_LINES_ALL.source_document_ID
27: AND CS_ESTIMATE_DETAILS.SOURCE_CODE = 'SD'
28: AND OE_ORDER_LINES_ALL.source_document_type_id = 7
29: AND oe_order_lines_all.line_id = p_order_line_id;
30:
31: l_return_status := TRUE;
32: -- Return TRUE as the order line is debrief order
33: RETURN l_return_status;

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

56:
57: l_message_id number;
58: l_transactable_flag mtl_system_items_b.mtl_transactions_enabled_flag%TYPE; --bug6140021
59: l_org_id number;
60: l_order_id oe_order_lines_all.header_id%TYPE; --Added for MACD Enhancement
61: l_vld_organization_id number;
62: l_inventory_item_id number;
63: l_line_category_code oe_order_lines_all.line_category_code%TYPE;
64: l_shippable_flag mtl_system_items_b.shippable_item_flag%TYPE;

Line 63: l_line_category_code oe_order_lines_all.line_category_code%TYPE;

59: l_org_id number;
60: l_order_id oe_order_lines_all.header_id%TYPE; --Added for MACD Enhancement
61: l_vld_organization_id number;
62: l_inventory_item_id number;
63: l_line_category_code oe_order_lines_all.line_category_code%TYPE;
64: l_shippable_flag mtl_system_items_b.shippable_item_flag%TYPE;
65: l_ordered_item varchar2(80);
66: l_item_type_code varchar2(30);
67: l_fulfilled_qty number;

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

99: l_end number;
100: l_num_threads number;
101: l_max_processes number;
102: l_om_session_key csi_utility_grp.config_session_key; --Added for MACD Enhancement
103: l_config_header_id oe_order_lines_all.config_header_id%type;--Added for MACD Enhancement
104: l_config_rev_nbr oe_order_lines_all.config_rev_nbr%type; --Added for MACD Enhancement
105: l_configuration_id oe_order_lines_all.configuration_id%type;--Added for MACD Enhancement
106: l_macd_processing boolean := FALSE; --Added for MACD Enhancement
107:

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

100: l_num_threads number;
101: l_max_processes number;
102: l_om_session_key csi_utility_grp.config_session_key; --Added for MACD Enhancement
103: l_config_header_id oe_order_lines_all.config_header_id%type;--Added for MACD Enhancement
104: l_config_rev_nbr oe_order_lines_all.config_rev_nbr%type; --Added for MACD Enhancement
105: l_configuration_id oe_order_lines_all.configuration_id%type;--Added for MACD Enhancement
106: l_macd_processing boolean := FALSE; --Added for MACD Enhancement
107:
108: BEGIN

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

101: l_max_processes number;
102: l_om_session_key csi_utility_grp.config_session_key; --Added for MACD Enhancement
103: l_config_header_id oe_order_lines_all.config_header_id%type;--Added for MACD Enhancement
104: l_config_rev_nbr oe_order_lines_all.config_rev_nbr%type; --Added for MACD Enhancement
105: l_configuration_id oe_order_lines_all.configuration_id%type;--Added for MACD Enhancement
106: l_macd_processing boolean := FALSE; --Added for MACD Enhancement
107:
108: BEGIN
109:

Line 163: FROM oe_order_lines_all

159: l_config_header_id,--Added for MACD Enhancement
160: l_config_rev_nbr, --Added for MACD Enhancement
161: l_configuration_id,--Added for MACD Enhancement
162: l_ato_line_id
163: FROM oe_order_lines_all
164: WHERE line_id = p_order_line_id;
165:
166: debug(' inventory_item_id : '||l_inventory_item_id);
167: