DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on OE_ORDER_LINES_ALL

Line 3158: FROM oe_order_lines_all l,

3154: ;
3155:
3156: CURSOR c_order_line IS
3157: SELECT 1
3158: FROM oe_order_lines_all l,
3159: mtl_system_items_b m,
3160: mtl_parameters mp,
3161: ic_item_mst i
3162: WHERE l.header_id = p_sample.order_id

Line 5248: FROM oe_order_lines_all l

5244: decode(l.shipment_number,'','','.'|| l.shipment_number) ||
5245: decode(l.option_number||l.component_number||l.service_number,'','','.'||l.option_number) ||
5246: decode(l.component_number||l.service_number,'','','.'|| l.component_number) ||
5247: decode(l.service_number,'','','.'|| l.service_number)
5248: FROM oe_order_lines_all l
5249: WHERE line_id = p_order_line_id ;
5250:
5251: CURSOR Cur_get_cust IS
5252: SELECT p.party_name /* cust_name */