APPS.OPI_EDW_COGS_FOPM_SZ dependencies on OP_ORDR_DTL

Line 15: OP_ORDR_DTL SD,

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
19: AND SH.orgn_code = OM.orgn_code

Line 62: op_ordr_Dtl ood

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:
66: CURSOR c_instance IS