VIEW: APPS.IC_ADJS_JNL_VW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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