DBA Data[Home] [Help]

APPS.OPI_PMI_COST dependencies on OPI_PMI_ORGN_DATE_GTMP

Line 117: INSERT INTO opi_pmi_orgn_date_gtmp(orgn_code, trans_date)

113:
114:
115: -- GET DISTINCT LIST OF ORGANIZATION.DATES (FOR FINDING EFFECTIVE PLCY)
116:
117: INSERT INTO opi_pmi_orgn_date_gtmp(orgn_code, trans_date)
118: SELECT /*+ ALL_ROWS */ DISTINCT orgn_code, trans_date
119: FROM opi_pmi_cost_param_gtmp;
120:
121:

Line 129: opi_pmi_orgn_date_gtmp od, sy_orgn_mst o, gl_plcy_mst g

125: (orgn_code, trans_date, co_code, cost_mthd, cost_basis)
126: SELECT /*+ ALL_ROWS */
127: od.orgn_code, od.trans_date, o.co_code, g.gl_cost_mthd, g.cost_basis
128: FROM
129: opi_pmi_orgn_date_gtmp od, sy_orgn_mst o, gl_plcy_mst g
130: WHERE
131: o.orgn_code = od.orgn_code
132: AND g.co_code = o.co_code;
133: