DBA Data[Home] [Help]

APPS.GMI_ICR04_XMLP_PKG dependencies on IC_CLDR_HDR

Line 131: IC_CLDR_HDR

127: AND T.TRANS_DATE >= (
128: SELECT
129: BEGIN_DATE
130: FROM
131: IC_CLDR_HDR
132: WHERE ORGN_CODE = T.ORGN_CODE
133: AND FISCAL_YEAR = FISCAL_YEAR )
134: AND T.TRANS_DATE <= TO_DATE
135: AND T.DOC_TYPE = 'PROD'

Line 156: IC_CLDR_HDR

152: WHERE T.TRANS_DATE >= (
153: SELECT
154: BEGIN_DATE
155: FROM
156: IC_CLDR_HDR
157: WHERE ORGN_CODE = T.ORGN_CODE
158: AND FISCAL_YEAR = FISCAL_YEAR )
159: AND T.TRANS_DATE <= TO_DATE
160: AND R.FLOW_TYPE = 0

Line 181: IC_CLDR_HDR

177: WHERE T.TRANS_DATE >= (
178: SELECT
179: BEGIN_DATE
180: FROM
181: IC_CLDR_HDR
182: WHERE ORGN_CODE = T.ORGN_CODE
183: AND FISCAL_YEAR = FISCAL_YEAR )
184: AND T.TRANS_DATE <= TO_DATE
185: AND T.DOC_TYPE = 'PROD'

Line 208: IC_CLDR_HDR

204: WHERE T.TRANS_DATE >= (
205: SELECT
206: BEGIN_DATE
207: FROM
208: IC_CLDR_HDR
209: WHERE ORGN_CODE = T.ORGN_CODE
210: AND FISCAL_YEAR = FISCAL_YEAR )
211: AND T.TRANS_DATE <= TO_DATE
212: AND R.FLOW_TYPE = 0