VIEW: APPS.JAI_CMN_RG_23_II_V

Source

View Text - Preformatted

SELECT A.Rowid Row_id, HR_ORG.name, MTLPRM.organization_code, HR_LOC.location_code, HR_LOC.Description, A.slno, TRUNC(A.Transaction_Date) Transaction_Date, DECODE(NVL(-A.Dr_Basic_Ed,0),0,A.Cr_Basic_Ed,-A.Dr_Basic_Ed) Basic_Ed, A.Organization_Id, A.Location_Id, A.Register_Type, DECODE(NVL(-A.Dr_Additional_Ed,0),0,A.Cr_Additional_Ed,-A.Dr_Additional_Ed) Additional_Ed, DECODE(NVL(-A.Dr_Other_Ed,0),0,A.Cr_Other_Ed, -A.Dr_Other_Ed) Other_Ed, A.Opening_Balance, A.Closing_Balance, A.Excise_Invoice_No, A.RECEIPT_REF, rcv.Receipt_num, A.reference_num, A.Register_ID_Part_I, A.fin_Year, A.register_id, A.vendor_Id, A.Vendor_Site_Id, A.Customer_ID, A.Customer_Site_Id, A.Charge_account_id, DECODE(NVL(-A.Dr_Additional_cvd,0),0,A.Cr_Additional_cvd,-A.Dr_Additional_cvd) Additional_cvd FROM JAI_CMN_RG_23AC_II_TRXS A, mtl_parameters mtlprm, HR_LOCATIONS_ALL HR_LOC, rcv_shipment_headers rcv, rcv_transactions rtran, HR_ALL_ORGANIZATION_UNITS hr_org WHERE HR_ORG.organization_id = mtlprm.organization_id AND HR_LOC.inventory_organization_id = A.organization_id AND A.Organization_id = mtlprm.Organization_Id AND A.Location_Id = HR_LOC.Location_Id AND RTRAN.transaction_id(+) = A.RECEIPT_REF AND RCV.shipment_header_id(+) = RTRAN.shipment_Header_id

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, HR_ORG.NAME
, MTLPRM.ORGANIZATION_CODE
, HR_LOC.LOCATION_CODE
, HR_LOC.DESCRIPTION
, A.SLNO
, TRUNC(A.TRANSACTION_DATE) TRANSACTION_DATE
, DECODE(NVL(-A.DR_BASIC_ED
, 0)
, 0
, A.CR_BASIC_ED
, -A.DR_BASIC_ED) BASIC_ED
, A.ORGANIZATION_ID
, A.LOCATION_ID
, A.REGISTER_TYPE
, DECODE(NVL(-A.DR_ADDITIONAL_ED
, 0)
, 0
, A.CR_ADDITIONAL_ED
, -A.DR_ADDITIONAL_ED) ADDITIONAL_ED
, DECODE(NVL(-A.DR_OTHER_ED
, 0)
, 0
, A.CR_OTHER_ED
, -A.DR_OTHER_ED) OTHER_ED
, A.OPENING_BALANCE
, A.CLOSING_BALANCE
, A.EXCISE_INVOICE_NO
, A.RECEIPT_REF
, RCV.RECEIPT_NUM
, A.REFERENCE_NUM
, A.REGISTER_ID_PART_I
, A.FIN_YEAR
, A.REGISTER_ID
, A.VENDOR_ID
, A.VENDOR_SITE_ID
, A.CUSTOMER_ID
, A.CUSTOMER_SITE_ID
, A.CHARGE_ACCOUNT_ID
, DECODE(NVL(-A.DR_ADDITIONAL_CVD
, 0)
, 0
, A.CR_ADDITIONAL_CVD
, -A.DR_ADDITIONAL_CVD) ADDITIONAL_CVD
FROM JAI_CMN_RG_23AC_II_TRXS A
, MTL_PARAMETERS MTLPRM
, HR_LOCATIONS_ALL HR_LOC
, RCV_SHIPMENT_HEADERS RCV
, RCV_TRANSACTIONS RTRAN
, HR_ALL_ORGANIZATION_UNITS HR_ORG
WHERE HR_ORG.ORGANIZATION_ID = MTLPRM.ORGANIZATION_ID
AND HR_LOC.INVENTORY_ORGANIZATION_ID = A.ORGANIZATION_ID
AND A.ORGANIZATION_ID = MTLPRM.ORGANIZATION_ID
AND A.LOCATION_ID = HR_LOC.LOCATION_ID
AND RTRAN.TRANSACTION_ID(+) = A.RECEIPT_REF
AND RCV.SHIPMENT_HEADER_ID(+) = RTRAN.SHIPMENT_HEADER_ID