VIEW: APPS.JAI_CMN_PLA_REGISTER_V

Source

View Text - Preformatted

SELECT A.ROWID row_id, HR_ORG.organization_name name, HR_ORG.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) Baisc_Ed, A.Organization_Id, A.Location_Id, decode(nvl(A.Dr_Additional_Ed,0),0,A.Cr_Additional_Ed,A.Dr_Additional_Ed) Additional_Ed,NVL(A.Dr_Other_Ed,A.Cr_Other_Ed) Other_Ed, A.Opening_Balance, A.Closing_Balance, NVL(A.Tr6_Challan_No,A.DR_INVOICE_NO) Invoice_Id, A.Ref_Document_Id,A.fin_Year,A.register_id,A.Vendor_Cust_Flag,A.vendor_Id, A.Vendor_Site_Id from JAI_CMN_RG_PLA_TRXS A, ORG_ORGANIZATION_DEFINITIONS HR_ORG, HR_LOCATIONS HR_LOC WHERE A.Organization_id = HR_ORG.Organization_Id AND A.Location_Id = HR_LOC.Location_Id AND A.organization_id in (select distinct organization_id from JAI_CMN_INVENTORY_ORGS) AND nvl(HR_ORG.operating_unit,0) = nvl(to_number(fnd_profile.value('ORG_ID')),0)

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, HR_ORG.ORGANIZATION_NAME NAME
, HR_ORG.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) BAISC_ED
, A.ORGANIZATION_ID
, A.LOCATION_ID
, DECODE(NVL(A.DR_ADDITIONAL_ED
, 0)
, 0
, A.CR_ADDITIONAL_ED
, A.DR_ADDITIONAL_ED) ADDITIONAL_ED
, NVL(A.DR_OTHER_ED
, A.CR_OTHER_ED) OTHER_ED
, A.OPENING_BALANCE
, A.CLOSING_BALANCE
, NVL(A.TR6_CHALLAN_NO
, A.DR_INVOICE_NO) INVOICE_ID
, A.REF_DOCUMENT_ID
, A.FIN_YEAR
, A.REGISTER_ID
, A.VENDOR_CUST_FLAG
, A.VENDOR_ID
, A.VENDOR_SITE_ID
FROM JAI_CMN_RG_PLA_TRXS A
, ORG_ORGANIZATION_DEFINITIONS HR_ORG
, HR_LOCATIONS HR_LOC
WHERE A.ORGANIZATION_ID = HR_ORG.ORGANIZATION_ID
AND A.LOCATION_ID = HR_LOC.LOCATION_ID
AND A.ORGANIZATION_ID IN (SELECT DISTINCT ORGANIZATION_ID
FROM JAI_CMN_INVENTORY_ORGS)
AND NVL(HR_ORG.OPERATING_UNIT
, 0) = NVL(TO_NUMBER(FND_PROFILE.VALUE('ORG_ID'))
, 0)