|
SELECT DISTINCT A.BUSINESS_UNIT , A.CM_BOOK , A.INV_ITEM_ID , A.TRANSACTION_GROUP AS TO_TRANX , A.PRODUCTION_ID AS TO_PRDNID , B.TRANSACTION_GROUP AS FROM_TRANX ,B.PRODUCTION_ID AS FROM_PRDNID FROM PS_CM_DEPLETE A , PS_CM_RECEIPTS B WHERE A.TRANSACTION_GROUP = '230' AND B.TRANSACTION_GROUP <> '060' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.CM_BOOK = B.CM_BOOK AND A.CM_DT_TIMESTAMP= B.DT_TIMESTAMP AND A.CM_SEQ_NBR = B.SEQ_NBR AND A.CM_DT_TIMESTAMP_A = B.CM_DT_TIMESTAMP_A AND A.CM_SEQ_NBR_A = B.CM_SEQ_NBR_A AND A.PRODUCTION_ID <> ' ' AND A.PRODUCTION_ID <> B.PRODUCTION_ID
|