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.OM_TAX_UTIL dependencies on OE_ORDER_LINES

Line 96: OE_ORDER_LINES_ALL L

92: (L.ORDERED_QUANTITY* nvl(P.ADJUSTED_AMOUNT,0)))
93: ,OE_ORDER_UTIL.G_Precision)
94: BULK COLLECT INTO l_charge_tbl
95: FROM OE_PRICE_ADJUSTMENTS P,
96: OE_ORDER_LINES_ALL L
97: WHERE P.HEADER_ID = p_header_id
98: AND P.LINE_ID = p_line_id
99: AND P.LINE_ID = L.LINE_ID
100: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'

Line 154: CURSOR detail_tax_charges_gt (p_header_id oe_order_lines.header_id%type, p_adj_id oe_order_lines.line_id%type )

150: IS
151: SELECT location_id
152: FROM hr_organization_units
153: WHERE organization_id = p_organization_id;
154: CURSOR detail_tax_charges_gt (p_header_id oe_order_lines.header_id%type, p_adj_id oe_order_lines.line_id%type )
155: IS
156: SELECT *
157: FROM ZX_DETAIL_TAX_LINES_GT
158: WHERE application_id = 660

Line 164: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type, p_line_id oe_order_lines.line_id%type)

160: AND event_class_code = 'SALES_TRANSACTION_TAX_QUOTE'
161: AND trx_id = p_header_id
162: AND trx_line_id = p_adj_id
163: AND trx_level_type = 'FREIGHT_CHARGE';
164: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type, p_line_id oe_order_lines.line_id%type)
165: IS
166: SELECT *
167: FROM ZX_DETAIL_TAX_LINES_GT
168: WHERE application_id = 660

Line 193: l_commitment_id oe_order_lines.commitment_id%type;

189: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%type;
190: l_precision fnd_currencies.precision%type;
191: Is_fmt BOOLEAN; --8431420
192: l_AR_Sys_Param_Rec ar_system_parameters_all%ROWTYPE;
193: l_commitment_id oe_order_lines.commitment_id%type;
194: l_cust_trx_type_id ra_cust_trx_types_all.cust_Trx_type_id%type;
195: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;
196: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;
197: l_ship_to_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;

Line 195: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;

191: Is_fmt BOOLEAN; --8431420
192: l_AR_Sys_Param_Rec ar_system_parameters_all%ROWTYPE;
193: l_commitment_id oe_order_lines.commitment_id%type;
194: l_cust_trx_type_id ra_cust_trx_types_all.cust_Trx_type_id%type;
195: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;
196: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;
197: l_ship_to_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;
198: l_ship_to_address_id NUMBER ;
199: l_ship_to_customer_id NUMBER ;

Line 196: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;

192: l_AR_Sys_Param_Rec ar_system_parameters_all%ROWTYPE;
193: l_commitment_id oe_order_lines.commitment_id%type;
194: l_cust_trx_type_id ra_cust_trx_types_all.cust_Trx_type_id%type;
195: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;
196: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;
197: l_ship_to_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;
198: l_ship_to_address_id NUMBER ;
199: l_ship_to_customer_id NUMBER ;
200: l_ship_to_postal_code VARCHAR2(60);

Line 217: l_tax_date oe_order_lines.tax_date%type;

213: l_bill_party_site_id NUMBER(15);
214: l_bill_location_id NUMBER(15);
215: l_internal_org_location_id NUMBER;
216: l_header_id oe_order_headers.header_id%type;
217: l_tax_date oe_order_lines.tax_date%type;
218: l_ordered_quantity oe_order_lines.ordered_quantity%type;
219: l_unit_selling_price oe_order_lines.unit_selling_price%type;
220: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
221: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;

Line 218: l_ordered_quantity oe_order_lines.ordered_quantity%type;

214: l_bill_location_id NUMBER(15);
215: l_internal_org_location_id NUMBER;
216: l_header_id oe_order_headers.header_id%type;
217: l_tax_date oe_order_lines.tax_date%type;
218: l_ordered_quantity oe_order_lines.ordered_quantity%type;
219: l_unit_selling_price oe_order_lines.unit_selling_price%type;
220: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
221: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
222: l_inventory_item_id oe_order_lines.inventory_item_id%type;

Line 219: l_unit_selling_price oe_order_lines.unit_selling_price%type;

215: l_internal_org_location_id NUMBER;
216: l_header_id oe_order_headers.header_id%type;
217: l_tax_date oe_order_lines.tax_date%type;
218: l_ordered_quantity oe_order_lines.ordered_quantity%type;
219: l_unit_selling_price oe_order_lines.unit_selling_price%type;
220: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
221: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
222: l_inventory_item_id oe_order_lines.inventory_item_id%type;
223: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;

Line 220: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;

216: l_header_id oe_order_headers.header_id%type;
217: l_tax_date oe_order_lines.tax_date%type;
218: l_ordered_quantity oe_order_lines.ordered_quantity%type;
219: l_unit_selling_price oe_order_lines.unit_selling_price%type;
220: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
221: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
222: l_inventory_item_id oe_order_lines.inventory_item_id%type;
223: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
224: l_fob_point_code oe_order_lines.fob_point_code%type;

Line 221: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;

217: l_tax_date oe_order_lines.tax_date%type;
218: l_ordered_quantity oe_order_lines.ordered_quantity%type;
219: l_unit_selling_price oe_order_lines.unit_selling_price%type;
220: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
221: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
222: l_inventory_item_id oe_order_lines.inventory_item_id%type;
223: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
224: l_fob_point_code oe_order_lines.fob_point_code%type;
225: l_tax_code VARCHAR2(50);

Line 222: l_inventory_item_id oe_order_lines.inventory_item_id%type;

218: l_ordered_quantity oe_order_lines.ordered_quantity%type;
219: l_unit_selling_price oe_order_lines.unit_selling_price%type;
220: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
221: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
222: l_inventory_item_id oe_order_lines.inventory_item_id%type;
223: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
224: l_fob_point_code oe_order_lines.fob_point_code%type;
225: l_tax_code VARCHAR2(50);
226: l_trx_shipping_date DATE;

Line 223: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;

219: l_unit_selling_price oe_order_lines.unit_selling_price%type;
220: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
221: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
222: l_inventory_item_id oe_order_lines.inventory_item_id%type;
223: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
224: l_fob_point_code oe_order_lines.fob_point_code%type;
225: l_tax_code VARCHAR2(50);
226: l_trx_shipping_date DATE;
227: l_trx_business_category VARCHAR2(240);

Line 224: l_fob_point_code oe_order_lines.fob_point_code%type;

220: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
221: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
222: l_inventory_item_id oe_order_lines.inventory_item_id%type;
223: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
224: l_fob_point_code oe_order_lines.fob_point_code%type;
225: l_tax_code VARCHAR2(50);
226: l_trx_shipping_date DATE;
227: l_trx_business_category VARCHAR2(240);
228: l_uom_code VARCHAR2(3);

Line 2080: FROM oe_order_lines_all

2076: l_num_tbl num_tbl := num_tbl();
2077:
2078: CURSOR order_line_cur IS
2079: SELECT line_id
2080: FROM oe_order_lines_all
2081: WHERE header_id = p_header_id
2082: AND open_flag = 'Y'; -- OPEN_FLAG added for bug 9897108
2083:
2084: BEGIN