DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on OE_ORDER_HEADERS_ALL

Line 3741: FROM oe_order_headers_all h,

3737: ;
3738:
3739: CURSOR c_order IS
3740: SELECT 1
3741: FROM oe_order_headers_all h,
3742: oe_transaction_types_tl t
3743: WHERE h.sold_to_org_id = p_sample.cust_id
3744: AND h.org_id = p_sample.org_id
3745: AND h.header_id = p_sample.order_id

Line 5904: FROM oe_order_headers_all h,

5900:
5901: CURSOR Cur_order_number IS
5902: SELECT h.order_number,
5903: t.name
5904: FROM oe_order_headers_all h,
5905: oe_transaction_types_tl t
5906: WHERE h.header_id = p_order_id
5907: AND h.order_type_id = t.transaction_type_id
5908: AND t.language = USERENV('LANG');