Product: | GMI - Process Manufacturing Inventory |
---|---|
Description: | Inventory Adjustment Journal view |
Implementation/DBA Data: | APPS.IC_ADJS_JNL_VW |
SELECT M.ORGN_CODE
, S.ASSIGNMENT_TYPE
, M.JOURNAL_NO
, M.JOURNAL_ID
, M.POSTED_IND
, M.DELETE_MARK
, M.JOURNAL_COMMENT
, M.PRINT_CNT
, M.POSTING_ID
, M.IN_USE
, D.TRANS_TYPE
, D.DOC_ID
, D.LINE_TYPE
, E.LINE_TYPE TO_LINE_TYPE
, D.LINE_ID
, E.LINE_ID TO_LINE_ID
, D.DOC_LINE
, E.DOC_LINE TO_DOC_LINE
, D.COMPLETED_IND
, D.DOC_DATE
, D.REASON_CODE
, R.REASON_TYPE
, R.REASON_DESC1
, D.ITEM_ID
, I.ITEM_NO
, I.ITEM_DESC1
, I.DUALUM_IND
, I.LOT_CTL
, I.SUBLOT_CTL
, I.LOCT_CTL ITEM_LOCT_CTL
, I.STATUS_CTL
, I.GRADE_CTL
, I.LOT_INDIVISIBLE
, I.LOT_STATUS DEFAULT_LOT_STATUS
, I.QC_GRADE DEFAULT_QC_GRADE
, D.LOT_ID
, DECODE(D.LOT_ID
, 0
, NULL
, L.LOT_NO) LOT_NO
, DECODE(D.LOT_ID
, 0
, NULL
, L.SUBLOT_NO) SUBLOT_NO
, DECODE(D.LOT_ID
, 0
, NULL
, L.LOT_DESC) LOT_DESC
, D.WHSE_CODE
, WD.WHSE_NAME WHSE_NAME
, WD.LOCT_CTL WHSE_LOCT_CTL
, O.CO_CODE WHSE_CO_CODE
, E.WHSE_CODE TO_WHSE_CODE
, WE.WHSE_NAME TO_WHSE_NAME
, WE.LOCT_CTL TO_WHSE_LOCT_CTL
, DECODE(D.LOCATION
, FND_PROFILE.VALUE('IC$DEFAULT_LOCT')
, NULL
, D.LOCATION ) LOCATION
, DECODE(D.LOCATION
, FND_PROFILE.VALUE('IC$DEFAULT_LOCT')
, NULL
, LOD.LOCT_DESC) LOCT_DESC
, DECODE(E.LOCATION
, FND_PROFILE.VALUE('IC$DEFAULT_LOCT')
, NULL
, E.LOCATION ) TO_LOCATION
, DECODE(E.LOCATION
, FND_PROFILE.VALUE('IC$DEFAULT_LOCT')
, NULL
, LOE.LOCT_DESC ) TO_LOCT_DESC
, D.ITEM_UM
, D.ITEM_UM2
, E.ITEM_UM TO_ITEM_UM
, E.ITEM_UM2 TO_ITEM_UM2
, D.LOT_STATUS
, LD.STATUS_DESC STATUS_DESC
, E.LOT_STATUS TO_LOT_STATUS
, LE.STATUS_DESC TO_STATUS_DESC
, D.QC_GRADE
, QD.QC_GRADE_DESC QC_GRADE_DESC
, E.QC_GRADE TO_QC_GRADE
, QE.QC_GRADE_DESC TO_QC_GRADE_DESC
, D.CO_CODE
, D.QTY
, D.QTY2
, E.QTY TO_QTY
, E.QTY2 TO_QTY2
, D.NO_INV
, D.NO_TRANS
, D.TRANS_FLAG
, D.TEXT_CODE
, D.TRANS_CNT
, D.ACCTG_UNIT_ID
, A.ACCTG_UNIT_NO
, A.ACCTG_UNIT_DESC
, D.ACCT_ID
, AC.ACCT_NO
, AC.ACCT_DESC ACCT_NO_DESC
, M.ATTRIBUTE1
, M.ATTRIBUTE2
, M.ATTRIBUTE3
, M.ATTRIBUTE4
, M.ATTRIBUTE5
, M.ATTRIBUTE6
, M.ATTRIBUTE7
, M.ATTRIBUTE8
, M.ATTRIBUTE9
, M.ATTRIBUTE10
, M.ATTRIBUTE11
, M.ATTRIBUTE12
, M.ATTRIBUTE13
, M.ATTRIBUTE14
, M.ATTRIBUTE15
, M.ATTRIBUTE16
, M.ATTRIBUTE17
, M.ATTRIBUTE18
, M.ATTRIBUTE19
, M.ATTRIBUTE20
, M.ATTRIBUTE21
, M.ATTRIBUTE22
, M.ATTRIBUTE23
, M.ATTRIBUTE24
, M.ATTRIBUTE25
, M.ATTRIBUTE26
, M.ATTRIBUTE27
, M.ATTRIBUTE28
, M.ATTRIBUTE29
, M.ATTRIBUTE30
, M.ATTRIBUTE_CATEGORY
, P.SET_OF_BOOKS_NAME SOBNAME
, P.SEGMENT_DELIMITER SEGMENT_DELIM
, D.PROGRAM_APPLICATION_ID
, D.PROGRAM_ID
, D.PROGRAM_UPDATE_DATE
, D.REQUEST_ID
, D.CREATED_BY
, D.CREATION_DATE
, D.LAST_UPDATE_DATE
, D.LAST_UPDATE_LOGIN
, D.LAST_UPDATED_BY
FROM IC_JRNL_MST M
, IC_ADJS_JNL D
, IC_ADJS_JNL E
, SY_REAS_CDS R
, IC_ITEM_MST I
, IC_LOTS_MST L
, SY_DOCS_SEQ S
, IC_WHSE_MST WD
, IC_WHSE_MST WE
, IC_LOTS_STS LD
, IC_LOTS_STS LE
, IC_LOCT_MST LOD
, IC_LOCT_MST LOE
, QC_GRAD_MST QD
, QC_GRAD_MST QE
, GL_ACCU_MST A
, GL_ACCT_MST AC
, GL_PLCY_MST P
, SY_ORGN_MST O
WHERE D.JOURNAL_ID = M.JOURNAL_ID
AND D.LINE_TYPE IN (0
, -1)
AND E.JOURNAL_ID (+) = D.JOURNAL_ID
AND E.DOC_ID (+) = D.DOC_ID
AND E.LINE_TYPE (+) = 1
AND I.ITEM_ID = D.ITEM_ID
AND R.REASON_CODE = D.REASON_CODE
AND L.ITEM_ID = D.ITEM_ID
AND L.LOT_ID = D.LOT_ID
AND S.DOC_TYPE = 'JRNL'
AND S.ORGN_CODE = M.ORGN_CODE
AND WD.WHSE_CODE (+) = D.WHSE_CODE
AND WE.WHSE_CODE (+) = E.WHSE_CODE
AND LD.LOT_STATUS (+) = D.LOT_STATUS
AND LE.LOT_STATUS (+) = E.LOT_STATUS
AND QD.QC_GRADE (+) = D.QC_GRADE
AND QE.QC_GRADE (+) = E.QC_GRADE
AND LOD.WHSE_CODE (+) = D.WHSE_CODE
AND LOD.LOCATION (+) = D.LOCATION
AND LOE.WHSE_CODE (+) = E.WHSE_CODE
AND LOE.LOCATION (+) = E.LOCATION
AND A.ACCTG_UNIT_ID (+) = D.ACCTG_UNIT_ID
AND AC.ACCT_ID (+) = D.ACCT_ID
AND O.ORGN_CODE (+) = WD.ORGN_CODE
AND P.CO_CODE (+) = O.CO_CODE
AND P.DELETE_MARK (+) = 0