APPS.OPI_EDW_COGS_FOPM_SZ dependencies on OP_ORDR_HDR

Line 14: OP_ORDR_HDR SH,

10: SELECT COUNT(*) INTO p_num_rows
11: FROM (
12: SELECT SH.order_id
13: FROM
14: OP_ORDR_HDR SH,
15: OP_ORDR_DTL SD,
16: SY_ORGN_MST OM,
17: GL_PLCY_MST PM
18: WHERE SH.order_id = sd.order_id

Line 61: FROM op_ORDR_hdr ooh,

57: SELECT avg(nvl(vsize(ooh.order_no), 0)) order_no,
58: avg(nvl(vsize(ood.line_no), 0)) line_no,
59: avg(nvl(vsize(ood.BILLING_CURRENCY), 0)) CURRENCY,
60: avg(nvl(vsize(OOD.SHIPCUST_ID), 0)) cust_id
61: FROM op_ORDR_hdr ooh,
62: op_ordr_Dtl ood
63: WHERE GREATEST(ooh.last_update_date,ood.last_update_date) between p_from_date and p_to_date;
64:
65: