APPS.GML_OP_CUST_MST_PKG dependencies on OP_ORDR_HDR

Line 69: FROM op_cust_mst cus, op_ordr_hdr hdr

65: hdr.order_id,
66: hdr.order_date,
67: hdr.billing_currency,
68: SUM(hdr.total_open_amount) total_open_amount
69: FROM op_cust_mst cus, op_ordr_hdr hdr
70: WHERE hdr.billcust_id = cus.cust_id and
71: hdr.completed_ind <> -1 and
72: hdr.delete_mark = 0 and
73: hdr.order_status < 20 and

Line 196: FROM op_cust_mst cus,op_ordr_hdr hdr

192: AND cust_id = X_cust_details.cust_id;
193: /*Commented following conditions
194: AND cust_id NOT IN
195: (SELECT cust_id
196: FROM op_cust_mst cus,op_ordr_hdr hdr
197: WHERE hdr.billcust_id = cus.cust_id
198: AND hdr.completed_ind <> -1
199: AND hdr.delete_mark = 0
200: AND hdr.order_status < 20

Line 229: FROM op_cust_mst cus,op_ordr_hdr hdr

225: WHERE bill_ind = 1
226: AND co_code = V_co_code
227: AND cust_id NOT IN
228: (SELECT cust_id
229: FROM op_cust_mst cus,op_ordr_hdr hdr
230: WHERE hdr.billcust_id = cus.cust_id
231: AND hdr.completed_ind <> -1
232: AND hdr.delete_mark = 0
233: AND hdr.order_status < 20