VIEW: APPS.PMIFV_QC_SAMPLE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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