View: JAI_CMN_RG_23_II_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_CMN_RG_23_II_V

View Text

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

Columns