[Home] [Help]
164: oel2.order_quantity_uom
165: into l_Charge_Details_rec.order_line_id,
166: l_Charge_Details_rec.quantity_required,
167: l_Charge_Details_rec.unit_of_measure_code
168: from oe_order_lines_all oel1,
169: oe_order_lines_all oel2
170: where oel1.line_id = p_order_line_id
171: and oel1.line_set_id = oel2.line_set_id
172: and oel2.line_id <> p_order_line_id
165: into l_Charge_Details_rec.order_line_id,
166: l_Charge_Details_rec.quantity_required,
167: l_Charge_Details_rec.unit_of_measure_code
168: from oe_order_lines_all oel1,
169: oe_order_lines_all oel2
170: where oel1.line_id = p_order_line_id
171: and oel1.line_set_id = oel2.line_set_id
172: and oel2.line_id <> p_order_line_id
173: and oel2.flow_status_code = 'AWAITING_RETURN';
1823:
1824: Cursor c_get_org (p_order_header_id number) is
1825: Select nvl(b.ship_from_org_id,a.ship_from_org_id)
1826: from oe_order_headers_all a,
1827: oe_order_lines_all b
1828: where a.header_id = b.header_id
1829: and a.header_id = p_order_header_id;
1830:
1831: Cursor c_get_prod_txn_status ( p_repair_line_id number ) is
3048: bulk collect into
3049: l_matching_rma_tbl
3050: from csd_product_transactions cpt,
3051: cs_estimate_details ced,
3052: oe_order_lines_all ool,
3053: csd_repairs cr,
3054: csd_repair_types_b crtb
3055: where
3056: cpt.repair_line_id = p_repair_line_id and
3120: bulk collect into
3121: l_matching_rma_tbl
3122: from csd_product_transactions cpt,
3123: cs_estimate_details ced,
3124: oe_order_lines_all ool,
3125: csd_repairs cr
3126: where
3127: cpt.repair_line_id = p_repair_line_id and
3128: cpt.action_type = 'RMA' and
3536:
3537: Cursor c_get_org (p_order_header_id number) is
3538: Select nvl(b.ship_from_org_id,a.ship_from_org_id)
3539: from oe_order_headers_all a,
3540: oe_order_lines_all b
3541: where a.header_id = b.header_id
3542: and a.header_id = p_order_header_id;
3543:
3544: Cursor c_get_prod_txn_status ( p_repair_line_id number ) is