APPS.GMD_SAMPLES_GRP dependencies on OE_ORDER_HEADERS_ALL

Line 3146: FROM oe_order_headers_all h,

3142: ;
3143:
3144: CURSOR c_order IS
3145: SELECT 1
3146: FROM oe_order_headers_all h,
3147: oe_transaction_types_tl t
3148: WHERE h.sold_to_org_id = p_sample.cust_id
3149: AND h.org_id = p_sample.org_id
3150: AND h.header_id = p_sample.order_id

Line 5236: FROM oe_order_headers_all h,

5232:
5233: CURSOR Cur_order_number IS
5234: SELECT h.order_number,
5235: t.name
5236: FROM oe_order_headers_all h,
5237: oe_transaction_types_tl t
5238: WHERE h.header_id = p_order_id
5239: AND h.order_type_id = t.transaction_type_id
5240: AND t.language = USERENV('LANG');