DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on OE_ORDER_LINES_ALL

Line 3753: FROM oe_order_lines_all l,

3749: ;
3750:
3751: CURSOR c_order_line IS
3752: SELECT 1
3753: FROM oe_order_lines_all l,
3754: mtl_system_items_b m,
3755: mtl_parameters mp,
3756: ic_item_mst i
3757: WHERE l.header_id = p_sample.order_id

Line 5916: FROM oe_order_lines_all l

5912: decode(l.shipment_number,'','','.'|| l.shipment_number) ||
5913: decode(l.option_number||l.component_number||l.service_number,'','','.'||l.option_number) ||
5914: decode(l.component_number||l.service_number,'','','.'|| l.component_number) ||
5915: decode(l.service_number,'','','.'|| l.service_number)
5916: FROM oe_order_lines_all l
5917: WHERE line_id = p_order_line_id ;
5918:
5919: CURSOR Cur_get_cust IS
5920: SELECT p.party_name /* cust_name */