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 81: l_tax_date oe_order_lines.tax_date%type;

77: l_internal_org_location_id NUMBER;
78: l_bill_to_customer_name VARCHAR2(360);
79: l_bill_to_customer_number VARCHAR2(30);
80: l_header_id oe_order_headers.header_id%type;
81: l_tax_date oe_order_lines.tax_date%type;
82: l_ordered_quantity oe_order_lines.ordered_quantity%type;
83: l_unit_selling_price oe_order_lines.unit_selling_price%type;
84: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
85: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;

Line 82: l_ordered_quantity oe_order_lines.ordered_quantity%type;

78: l_bill_to_customer_name VARCHAR2(360);
79: l_bill_to_customer_number VARCHAR2(30);
80: l_header_id oe_order_headers.header_id%type;
81: l_tax_date oe_order_lines.tax_date%type;
82: l_ordered_quantity oe_order_lines.ordered_quantity%type;
83: l_unit_selling_price oe_order_lines.unit_selling_price%type;
84: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
85: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
86: l_inventory_item_id oe_order_lines.inventory_item_id%type;

Line 83: l_unit_selling_price oe_order_lines.unit_selling_price%type;

79: l_bill_to_customer_number VARCHAR2(30);
80: l_header_id oe_order_headers.header_id%type;
81: l_tax_date oe_order_lines.tax_date%type;
82: l_ordered_quantity oe_order_lines.ordered_quantity%type;
83: l_unit_selling_price oe_order_lines.unit_selling_price%type;
84: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
85: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
86: l_inventory_item_id oe_order_lines.inventory_item_id%type;
87: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;

Line 84: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;

80: l_header_id oe_order_headers.header_id%type;
81: l_tax_date oe_order_lines.tax_date%type;
82: l_ordered_quantity oe_order_lines.ordered_quantity%type;
83: l_unit_selling_price oe_order_lines.unit_selling_price%type;
84: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
85: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
86: l_inventory_item_id oe_order_lines.inventory_item_id%type;
87: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
88: l_ship_from_location_id NUMBER;

Line 85: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;

81: l_tax_date oe_order_lines.tax_date%type;
82: l_ordered_quantity oe_order_lines.ordered_quantity%type;
83: l_unit_selling_price oe_order_lines.unit_selling_price%type;
84: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
85: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
86: l_inventory_item_id oe_order_lines.inventory_item_id%type;
87: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
88: l_ship_from_location_id NUMBER;
89: l_fob_point_code oe_order_lines.fob_point_code%type;

Line 86: l_inventory_item_id oe_order_lines.inventory_item_id%type;

82: l_ordered_quantity oe_order_lines.ordered_quantity%type;
83: l_unit_selling_price oe_order_lines.unit_selling_price%type;
84: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
85: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
86: l_inventory_item_id oe_order_lines.inventory_item_id%type;
87: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
88: l_ship_from_location_id NUMBER;
89: l_fob_point_code oe_order_lines.fob_point_code%type;
90: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;

Line 87: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;

83: l_unit_selling_price oe_order_lines.unit_selling_price%type;
84: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
85: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
86: l_inventory_item_id oe_order_lines.inventory_item_id%type;
87: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
88: l_ship_from_location_id NUMBER;
89: l_fob_point_code oe_order_lines.fob_point_code%type;
90: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;
91: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;

Line 89: l_fob_point_code oe_order_lines.fob_point_code%type;

85: l_tax_exempt_reason oe_order_lines.tax_exempt_reason_code%type;
86: l_inventory_item_id oe_order_lines.inventory_item_id%type;
87: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
88: l_ship_from_location_id NUMBER;
89: l_fob_point_code oe_order_lines.fob_point_code%type;
90: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;
91: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;
92: l_application_id NUMBER;
93: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE;

Line 90: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;

86: l_inventory_item_id oe_order_lines.inventory_item_id%type;
87: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
88: l_ship_from_location_id NUMBER;
89: l_fob_point_code oe_order_lines.fob_point_code%type;
90: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;
91: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;
92: l_application_id NUMBER;
93: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE;
94: l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_code%TYPE ;

Line 91: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;

87: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
88: l_ship_from_location_id NUMBER;
89: l_fob_point_code oe_order_lines.fob_point_code%type;
90: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;
91: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;
92: l_application_id NUMBER;
93: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE;
94: l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_code%TYPE ;
95: l_trx_level_type_crsr zx_detail_tax_lines_gt.trx_level_type%TYPE;

Line 105: l_commitment_id oe_order_lines.commitment_id%type;

101: l_header_org_id NUMBER;
102: l_conversion_rate NUMBER;
103: l_precision fnd_currencies.precision%type;
104: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%type;
105: l_commitment_id oe_order_lines.commitment_id%type;
106: l_cust_trx_type_id ra_cust_trx_types_all.cust_Trx_type_id%type;
107: l_AR_Sys_Param_Rec ar_system_parameters_all%ROWTYPE;
108: l_product_type zx_product_types_def_v.classification_code%TYPE;
109: --x_otoc_le_info_rec XLE_BUSINESSINFO_GRP.otoc_le_rec;

Line 146: oe_order_lines.header_id,

142:
143: /*
144: CURSOR oeorderline IS
145: SELECT
146: oe_order_lines.header_id,
147: oe_order_lines.tax_date,
148: oe_order_lines.pricing_quantity,
149: oe_order_lines.unit_selling_price,
150: oe_order_lines.tax_exempt_number,

Line 147: oe_order_lines.tax_date,

143: /*
144: CURSOR oeorderline IS
145: SELECT
146: oe_order_lines.header_id,
147: oe_order_lines.tax_date,
148: oe_order_lines.pricing_quantity,
149: oe_order_lines.unit_selling_price,
150: oe_order_lines.tax_exempt_number,
151: oe_order_lines.tax_exempt_reason_code,

Line 148: oe_order_lines.pricing_quantity,

144: CURSOR oeorderline IS
145: SELECT
146: oe_order_lines.header_id,
147: oe_order_lines.tax_date,
148: oe_order_lines.pricing_quantity,
149: oe_order_lines.unit_selling_price,
150: oe_order_lines.tax_exempt_number,
151: oe_order_lines.tax_exempt_reason_code,
152: oe_order_lines.inventory_item_id,

Line 149: oe_order_lines.unit_selling_price,

145: SELECT
146: oe_order_lines.header_id,
147: oe_order_lines.tax_date,
148: oe_order_lines.pricing_quantity,
149: oe_order_lines.unit_selling_price,
150: oe_order_lines.tax_exempt_number,
151: oe_order_lines.tax_exempt_reason_code,
152: oe_order_lines.inventory_item_id,
153: oe_order_lines.ship_from_org_id,

Line 150: oe_order_lines.tax_exempt_number,

146: oe_order_lines.header_id,
147: oe_order_lines.tax_date,
148: oe_order_lines.pricing_quantity,
149: oe_order_lines.unit_selling_price,
150: oe_order_lines.tax_exempt_number,
151: oe_order_lines.tax_exempt_reason_code,
152: oe_order_lines.inventory_item_id,
153: oe_order_lines.ship_from_org_id,
154: oe_order_lines.fob_point_code,

Line 151: oe_order_lines.tax_exempt_reason_code,

147: oe_order_lines.tax_date,
148: oe_order_lines.pricing_quantity,
149: oe_order_lines.unit_selling_price,
150: oe_order_lines.tax_exempt_number,
151: oe_order_lines.tax_exempt_reason_code,
152: oe_order_lines.inventory_item_id,
153: oe_order_lines.ship_from_org_id,
154: oe_order_lines.fob_point_code,
155: oe_order_lines.tax_code,

Line 152: oe_order_lines.inventory_item_id,

148: oe_order_lines.pricing_quantity,
149: oe_order_lines.unit_selling_price,
150: oe_order_lines.tax_exempt_number,
151: oe_order_lines.tax_exempt_reason_code,
152: oe_order_lines.inventory_item_id,
153: oe_order_lines.ship_from_org_id,
154: oe_order_lines.fob_point_code,
155: oe_order_lines.tax_code,
156: NVL(oe_order_lines.actual_shipment_date, oe_order_lines.schedule_ship_date),

Line 153: oe_order_lines.ship_from_org_id,

149: oe_order_lines.unit_selling_price,
150: oe_order_lines.tax_exempt_number,
151: oe_order_lines.tax_exempt_reason_code,
152: oe_order_lines.inventory_item_id,
153: oe_order_lines.ship_from_org_id,
154: oe_order_lines.fob_point_code,
155: oe_order_lines.tax_code,
156: NVL(oe_order_lines.actual_shipment_date, oe_order_lines.schedule_ship_date),
157: DECODE( oe_order_lines.global_attribute_category,

Line 154: oe_order_lines.fob_point_code,

150: oe_order_lines.tax_exempt_number,
151: oe_order_lines.tax_exempt_reason_code,
152: oe_order_lines.inventory_item_id,
153: oe_order_lines.ship_from_org_id,
154: oe_order_lines.fob_point_code,
155: oe_order_lines.tax_code,
156: NVL(oe_order_lines.actual_shipment_date, oe_order_lines.schedule_ship_date),
157: DECODE( oe_order_lines.global_attribute_category,
158: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute6,

Line 155: oe_order_lines.tax_code,

151: oe_order_lines.tax_exempt_reason_code,
152: oe_order_lines.inventory_item_id,
153: oe_order_lines.ship_from_org_id,
154: oe_order_lines.fob_point_code,
155: oe_order_lines.tax_code,
156: NVL(oe_order_lines.actual_shipment_date, oe_order_lines.schedule_ship_date),
157: DECODE( oe_order_lines.global_attribute_category,
158: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
159: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute6,

Line 156: NVL(oe_order_lines.actual_shipment_date, oe_order_lines.schedule_ship_date),

152: oe_order_lines.inventory_item_id,
153: oe_order_lines.ship_from_org_id,
154: oe_order_lines.fob_point_code,
155: oe_order_lines.tax_code,
156: NVL(oe_order_lines.actual_shipment_date, oe_order_lines.schedule_ship_date),
157: DECODE( oe_order_lines.global_attribute_category,
158: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
159: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
160: 'JL.CO.OEXOEORD.LINES', oe_order_lines.global_attribute6,NULL) ,

Line 157: DECODE( oe_order_lines.global_attribute_category,

153: oe_order_lines.ship_from_org_id,
154: oe_order_lines.fob_point_code,
155: oe_order_lines.tax_code,
156: NVL(oe_order_lines.actual_shipment_date, oe_order_lines.schedule_ship_date),
157: DECODE( oe_order_lines.global_attribute_category,
158: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
159: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
160: 'JL.CO.OEXOEORD.LINES', oe_order_lines.global_attribute6,NULL) ,
161: Decode(oe_order_lines.global_attribute_category,

Line 158: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute6,

154: oe_order_lines.fob_point_code,
155: oe_order_lines.tax_code,
156: NVL(oe_order_lines.actual_shipment_date, oe_order_lines.schedule_ship_date),
157: DECODE( oe_order_lines.global_attribute_category,
158: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
159: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
160: 'JL.CO.OEXOEORD.LINES', oe_order_lines.global_attribute6,NULL) ,
161: Decode(oe_order_lines.global_attribute_category,
162: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute5,

Line 159: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute6,

155: oe_order_lines.tax_code,
156: NVL(oe_order_lines.actual_shipment_date, oe_order_lines.schedule_ship_date),
157: DECODE( oe_order_lines.global_attribute_category,
158: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
159: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
160: 'JL.CO.OEXOEORD.LINES', oe_order_lines.global_attribute6,NULL) ,
161: Decode(oe_order_lines.global_attribute_category,
162: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
163: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute5,

Line 160: 'JL.CO.OEXOEORD.LINES', oe_order_lines.global_attribute6,NULL) ,

156: NVL(oe_order_lines.actual_shipment_date, oe_order_lines.schedule_ship_date),
157: DECODE( oe_order_lines.global_attribute_category,
158: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
159: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
160: 'JL.CO.OEXOEORD.LINES', oe_order_lines.global_attribute6,NULL) ,
161: Decode(oe_order_lines.global_attribute_category,
162: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
163: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
164: 'JL.CO.OEXOEORD.LINES',oe_order_lines.global_attribute5,NULL) ,

Line 161: Decode(oe_order_lines.global_attribute_category,

157: DECODE( oe_order_lines.global_attribute_category,
158: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
159: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
160: 'JL.CO.OEXOEORD.LINES', oe_order_lines.global_attribute6,NULL) ,
161: Decode(oe_order_lines.global_attribute_category,
162: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
163: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
164: 'JL.CO.OEXOEORD.LINES',oe_order_lines.global_attribute5,NULL) ,
165: NVL(oe_order_lines.pricing_quantity_uom, oe_order_lines.order_quantity_uom) ,

Line 162: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute5,

158: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
159: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
160: 'JL.CO.OEXOEORD.LINES', oe_order_lines.global_attribute6,NULL) ,
161: Decode(oe_order_lines.global_attribute_category,
162: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
163: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
164: 'JL.CO.OEXOEORD.LINES',oe_order_lines.global_attribute5,NULL) ,
165: NVL(oe_order_lines.pricing_quantity_uom, oe_order_lines.order_quantity_uom) ,
166: DECODE(oe_order_lines.user_item_description, NULL, 'MEMO', 'SERVICE'),

Line 163: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute5,

159: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute6,
160: 'JL.CO.OEXOEORD.LINES', oe_order_lines.global_attribute6,NULL) ,
161: Decode(oe_order_lines.global_attribute_category,
162: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
163: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
164: 'JL.CO.OEXOEORD.LINES',oe_order_lines.global_attribute5,NULL) ,
165: NVL(oe_order_lines.pricing_quantity_uom, oe_order_lines.order_quantity_uom) ,
166: DECODE(oe_order_lines.user_item_description, NULL, 'MEMO', 'SERVICE'),
167: oe_order_lines.line_number ,

Line 164: 'JL.CO.OEXOEORD.LINES',oe_order_lines.global_attribute5,NULL) ,

160: 'JL.CO.OEXOEORD.LINES', oe_order_lines.global_attribute6,NULL) ,
161: Decode(oe_order_lines.global_attribute_category,
162: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
163: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
164: 'JL.CO.OEXOEORD.LINES',oe_order_lines.global_attribute5,NULL) ,
165: NVL(oe_order_lines.pricing_quantity_uom, oe_order_lines.order_quantity_uom) ,
166: DECODE(oe_order_lines.user_item_description, NULL, 'MEMO', 'SERVICE'),
167: oe_order_lines.line_number ,
168: oe_order_lines.user_item_description

Line 165: NVL(oe_order_lines.pricing_quantity_uom, oe_order_lines.order_quantity_uom) ,

161: Decode(oe_order_lines.global_attribute_category,
162: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
163: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
164: 'JL.CO.OEXOEORD.LINES',oe_order_lines.global_attribute5,NULL) ,
165: NVL(oe_order_lines.pricing_quantity_uom, oe_order_lines.order_quantity_uom) ,
166: DECODE(oe_order_lines.user_item_description, NULL, 'MEMO', 'SERVICE'),
167: oe_order_lines.line_number ,
168: oe_order_lines.user_item_description
169: FROM oe_order_lines, oe_system_parameters

Line 166: DECODE(oe_order_lines.user_item_description, NULL, 'MEMO', 'SERVICE'),

162: 'JL.AR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
163: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
164: 'JL.CO.OEXOEORD.LINES',oe_order_lines.global_attribute5,NULL) ,
165: NVL(oe_order_lines.pricing_quantity_uom, oe_order_lines.order_quantity_uom) ,
166: DECODE(oe_order_lines.user_item_description, NULL, 'MEMO', 'SERVICE'),
167: oe_order_lines.line_number ,
168: oe_order_lines.user_item_description
169: FROM oe_order_lines, oe_system_parameters
170: WHERE oe_order_lines.org_id = oe_system_parameters.org_id

Line 167: oe_order_lines.line_number ,

163: 'JL.BR.OEXOEORD.LINES', oe_order_lines.global_attribute5,
164: 'JL.CO.OEXOEORD.LINES',oe_order_lines.global_attribute5,NULL) ,
165: NVL(oe_order_lines.pricing_quantity_uom, oe_order_lines.order_quantity_uom) ,
166: DECODE(oe_order_lines.user_item_description, NULL, 'MEMO', 'SERVICE'),
167: oe_order_lines.line_number ,
168: oe_order_lines.user_item_description
169: FROM oe_order_lines, oe_system_parameters
170: WHERE oe_order_lines.org_id = oe_system_parameters.org_id
171: --AND header_id = p_header_id

Line 168: oe_order_lines.user_item_description

164: 'JL.CO.OEXOEORD.LINES',oe_order_lines.global_attribute5,NULL) ,
165: NVL(oe_order_lines.pricing_quantity_uom, oe_order_lines.order_quantity_uom) ,
166: DECODE(oe_order_lines.user_item_description, NULL, 'MEMO', 'SERVICE'),
167: oe_order_lines.line_number ,
168: oe_order_lines.user_item_description
169: FROM oe_order_lines, oe_system_parameters
170: WHERE oe_order_lines.org_id = oe_system_parameters.org_id
171: --AND header_id = p_header_id
172: AND line_id = p_line_rec.line_id;

Line 169: FROM oe_order_lines, oe_system_parameters

165: NVL(oe_order_lines.pricing_quantity_uom, oe_order_lines.order_quantity_uom) ,
166: DECODE(oe_order_lines.user_item_description, NULL, 'MEMO', 'SERVICE'),
167: oe_order_lines.line_number ,
168: oe_order_lines.user_item_description
169: FROM oe_order_lines, oe_system_parameters
170: WHERE oe_order_lines.org_id = oe_system_parameters.org_id
171: --AND header_id = p_header_id
172: AND line_id = p_line_rec.line_id;
173: */

Line 170: WHERE oe_order_lines.org_id = oe_system_parameters.org_id

166: DECODE(oe_order_lines.user_item_description, NULL, 'MEMO', 'SERVICE'),
167: oe_order_lines.line_number ,
168: oe_order_lines.user_item_description
169: FROM oe_order_lines, oe_system_parameters
170: WHERE oe_order_lines.org_id = oe_system_parameters.org_id
171: --AND header_id = p_header_id
172: AND line_id = p_line_rec.line_id;
173: */
174:

Line 181: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type,

177: from hr_organization_units
178: where organization_id = p_organization_id;
179:
180:
181: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type,
182: p_line_id oe_order_lines.line_id%type)
183: is
184: select * from
185: ZX_DETAIL_TAX_LINES_GT

Line 182: p_line_id oe_order_lines.line_id%type)

178: where organization_id = p_organization_id;
179:
180:
181: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type,
182: p_line_id oe_order_lines.line_id%type)
183: is
184: select * from
185: ZX_DETAIL_TAX_LINES_GT
186: where

Line 1229: FROM oe_order_lines_all

1225: l_num_tbl num_tbl := num_tbl();
1226:
1227: CURSOR order_line_cur IS
1228: SELECT line_id
1229: FROM oe_order_lines_all
1230: WHERE header_id = p_header_id;
1231:
1232: BEGIN
1233: -- performance bug 4255597