Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | QC Samples Full View |
Implementation/DBA Data: | APPS.PMIFV_QC_SAMPLE_V |
SELECT QS.SAMPLE_ID AS SAMPLE_ID
, QS.ORGN_CODE AS ORGANIZATION_CODE
, QS.SAMPLE_NO AS SAMPLE_NO
, QS.SAMPLE_DESC AS SAMPLE_DESCRIPTION
, QS.WHSE_CODE AS WAREHOUSE_CODE
, QS.LOCATION AS LOCATION
, QS.SAMPLE_DATE AS SAMPLE_DATE
, USR.USER_NAME AS SAMPLED_BY
, QS.SAMPLE_QTY AS SAMPLE_QTY
, QS.SAMPLE_UM AS SAMPLE_UOM
, QS.DELETE_MARK AS DELETE_MARK
, QS.EXTERNAL_ID AS EXTERNAL_ID
, ITM.ITEM_NO AS ITEM_NUMBER
, ITM.ITEM_DESC1 AS ITEM_DESCRIPTION
, ITM.ITEM_UM AS ITEM_UOM
, ITM.INV_TYPE AS INVENTORY_TYPE
, FM.FORMULA_ID AS FORMULA_ID
, FM.FORMULA_NO AS FORMULA_NUMBER
, FM.FORMULA_VERS AS FORMULA_VERSION
, LOT.LOT_NO AS LOT_NUMBER
, LOT.SUBLOT_NO AS SUB_LOT_NUMBER
, PM.BATCH_NO AS BATCH_NUMBER
, PARTY.PARTY_NUMBER AS CUSTOMER_NUMBER
, PARTY.PARTY_NAME AS CUSTOMER_NAME
, PO.VENDOR_NO AS VENDOR_NUMBER
, PO.VENDOR_NAME AS VENDOR_NAME
, OPER.OPRN_ID AS OPERATION_ID
, OPER.OPRN_NO AS OPERATION_NUMBER
, OPER.OPRN_VERS AS OPERATION_VERSION
, ROUT.ROUTING_ID AS ROUTING_ID
, ROUT.ROUTING_NO AS ROUTING_NUMBER
, ROUT.ROUTING_VERS AS ROUTING_VERSION
, FMR.ROUTINGSTEP_NO AS ROUTING_STEP_NUMBER
, QS.CUST_ID
, QS.SHIP_TO_SITE_ID
FROM QC_SMPL_MST QS
, FM_FORM_MST FM
, GME_BATCH_HEADER PM
, FM_OPRN_MST OPER
, HZ_CUST_ACCOUNTS_ALL CUST_ACCT
, HZ_PARTIES PARTY
, IC_ITEM_MST ITM
, IC_LOTS_MST LOT
, FND_USER USR
, FM_ROUT_HDR ROUT
, PO_VEND_MST PO
, FM_ROUT_DTL FMR
WHERE FM.FORMULA_ID(+) = QS.FORMULA_ID
AND FMR.ROUTINGSTEP_ID(+) = QS.ROUTINGSTEP_ID
AND ROUT.ROUTING_ID(+) = QS.ROUTING_ID
AND OPER.OPRN_ID(+) = QS.OPRN_ID
AND QS.ITEM_ID = ITM.ITEM_ID
AND PM.BATCH_ID(+) = QS.BATCH_ID
AND LOT.LOT_ID(+) = QS.LOT_ID
AND LOT.ITEM_ID(+) = QS.ITEM_ID
AND PARTY.PARTY_ID(+) = CUST_ACCT.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID(+) = QS.CUST_ID
AND PO.VENDOR_ID(+) = QS.VENDOR_ID
AND QS.SAMPLED_BY = USR.USER_ID
AND (( QS.ORGN_CODE IS NULL) OR ('TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(QS.ORGN_CODE) ))