Product: | JA - Asia/Pacific Localizations |
---|---|
Description: | |
Implementation/DBA Data: | APPS.JAI_CMN_PLA_REGISTER_V |
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)