eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PMIFV_QC_PRODUCTION_SPEC_V

Source

View Text - Preformatted


SELECT QS.qc_spec_id AS quality_control_spec_id, QS.qcassy_typ_id AS assay_type_id, QS.orgn_code AS organization_code, QS.whse_code AS warehouse_code, QS.location AS location, QS.doc_type AS document_type, QS.vendor_specification AS vendor_specification, QS.vendor_certification AS vendor_certification, QS.cust_specification AS customer_specification, QS.cust_certification AS customer_certification, QS.assay_code AS assay_code, QS.text_spec AS text_spec, QS.min_spec AS min_spec, QS.max_spec AS max_spec, QS.target_spec AS target_spec, QS.qcunit_code AS Quality_Control_Unit_Code, QS.from_date AS from_date, QS.to_date AS to_date, QS.outaction_code AS out_of_action_code, QS.outaction_interval AS out_of_action_interval, QS.preference AS preference, QS.print_coa_shipped AS print_coa_shipped, QS.print_coa_invoiced AS print_coa_invoiced, QS.vendor_coa_required AS vendor_coa_required, QS.delete_mark AS delete_mark, QS.routingstep_no as routing_step_number, ' ' AS customer_number, ' ' AS customer_name, IM.item_no AS item_number, IM.item_desc1 AS item_description, 0 AS vendor_id, ' ' AS vendor_number, ' ' AS vendor_name, fm.formula_id as formula_id, fm.formula_no as formula_number, fm.formula_vers as formula_version, lo.lot_no AS lot_number, lo.sublot_no as sub_lot_number, pm.batch_no AS batch_number, ro.routing_id AS routing_id, ro.routing_no AS routing_number, ro.routing_vers as routing_version, op.oprn_id AS operation_id, op.oprn_no AS operation_number, op.oprn_vers AS operation_version, activelkup.meaning as effective FROM qc_spec_mst QS, ic_item_mst IM, fm_form_mst fm, ic_lots_mst lo, GME_BATCH_HEADER pm, fm_rout_hdr ro, fm_oprn_mst op, FND_LOOKUPS activelkup WHERE QS.item_id = IM.item_id AND QS.formula_id = fm.formula_id AND QS.lot_id = lo.lot_id(+) AND QS.item_id = lo.item_id(+) AND QS.batch_id = pm.batch_id AND QS.routing_id = ro.routing_id(+) AND QS.oprn_id = op.oprn_id(+) AND activelkup.lookup_type = 'PMI_ACTIVE' AND activelkup.lookup_code = 1 AND (sysdate >= qs.from_date and sysdate <= qs.to_date) UNION SELECT QS.qc_spec_id AS quality_control_spec_id, QS.qcassy_typ_id AS assay_type_id, QS.orgn_code AS organization_code, QS.whse_code AS warehouse_code, QS.location AS location, QS.doc_type AS document_type, QS.vendor_specification AS vendor_specification, QS.vendor_certification AS vendor_certification, QS.cust_specification AS customer_specification, QS.cust_certification AS customer_certification, QS.assay_code AS assay_code, QS.text_spec AS text_spec, QS.min_spec AS min_spec, QS.max_spec AS max_spec, QS.target_spec AS target_spec, QS.qcunit_code AS Quality_Control_Unit_Code, QS.from_date AS from_date, QS.to_date AS to_date, QS.outaction_code AS out_of_action_code, QS.outaction_interval AS out_of_action_interval, QS.preference AS preference, QS.print_coa_shipped AS print_coa_shipped, QS.print_coa_invoiced AS print_coa_invoiced, QS.vendor_coa_required AS vendor_coa_required, QS.delete_mark AS delete_mark, QS.routingstep_no as routing_step_number, ' ' AS customer_number, ' ' AS customer_name, IM.item_no AS item_number, IM.item_desc1 AS item_description, 0 AS vendor_id, ' ' AS vendor_number, ' ' AS vendor_name, fm.formula_id as formula_id, fm.formula_no as formula_number, fm.formula_vers as formula_version, lo.lot_no AS lot_number, lo.sublot_no as sub_lot_number, pm.batch_no AS batch_number, ro.routing_id AS routing_id, ro.routing_no AS routing_number, ro.routing_vers as routing_version, op.oprn_id AS operation_id, op.oprn_no AS operation_number, op.oprn_vers AS operation_version, activelkup.meaning as effective FROM qc_spec_mst QS, ic_item_mst IM, fm_form_mst fm, ic_lots_mst lo, GME_BATCH_HEADER pm, fm_rout_hdr ro, fm_oprn_mst op, FND_LOOKUPS activelkup WHERE QS.item_id = IM.item_id AND QS.formula_id = fm.formula_id AND QS.lot_id = lo.lot_id(+) AND QS.item_id = lo.item_id(+) AND QS.batch_id = pm.batch_id AND QS.routing_id = ro.routing_id(+) AND QS.oprn_id = op.oprn_id(+) AND activelkup.lookup_type = 'PMI_ACTIVE' AND activelkup.lookup_code = 2 AND ( sysdate < qs.from_date OR sysdate > qs.to_date)

View Text - HTML Formatted

SELECT QS.QC_SPEC_ID AS QUALITY_CONTROL_SPEC_ID
, QS.QCASSY_TYP_ID AS ASSAY_TYPE_ID
, QS.ORGN_CODE AS ORGANIZATION_CODE
, QS.WHSE_CODE AS WAREHOUSE_CODE
, QS.LOCATION AS LOCATION
, QS.DOC_TYPE AS DOCUMENT_TYPE
, QS.VENDOR_SPECIFICATION AS VENDOR_SPECIFICATION
, QS.VENDOR_CERTIFICATION AS VENDOR_CERTIFICATION
, QS.CUST_SPECIFICATION AS CUSTOMER_SPECIFICATION
, QS.CUST_CERTIFICATION AS CUSTOMER_CERTIFICATION
, QS.ASSAY_CODE AS ASSAY_CODE
, QS.TEXT_SPEC AS TEXT_SPEC
, QS.MIN_SPEC AS MIN_SPEC
, QS.MAX_SPEC AS MAX_SPEC
, QS.TARGET_SPEC AS TARGET_SPEC
, QS.QCUNIT_CODE AS QUALITY_CONTROL_UNIT_CODE
, QS.FROM_DATE AS FROM_DATE
, QS.TO_DATE AS TO_DATE
, QS.OUTACTION_CODE AS OUT_OF_ACTION_CODE
, QS.OUTACTION_INTERVAL AS OUT_OF_ACTION_INTERVAL
, QS.PREFERENCE AS PREFERENCE
, QS.PRINT_COA_SHIPPED AS PRINT_COA_SHIPPED
, QS.PRINT_COA_INVOICED AS PRINT_COA_INVOICED
, QS.VENDOR_COA_REQUIRED AS VENDOR_COA_REQUIRED
, QS.DELETE_MARK AS DELETE_MARK
, QS.ROUTINGSTEP_NO AS ROUTING_STEP_NUMBER
, ' ' AS CUSTOMER_NUMBER
, ' ' AS CUSTOMER_NAME
, IM.ITEM_NO AS ITEM_NUMBER
, IM.ITEM_DESC1 AS ITEM_DESCRIPTION
, 0 AS VENDOR_ID
, ' ' AS VENDOR_NUMBER
, ' ' AS VENDOR_NAME
, FM.FORMULA_ID AS FORMULA_ID
, FM.FORMULA_NO AS FORMULA_NUMBER
, FM.FORMULA_VERS AS FORMULA_VERSION
, LO.LOT_NO AS LOT_NUMBER
, LO.SUBLOT_NO AS SUB_LOT_NUMBER
, PM.BATCH_NO AS BATCH_NUMBER
, RO.ROUTING_ID AS ROUTING_ID
, RO.ROUTING_NO AS ROUTING_NUMBER
, RO.ROUTING_VERS AS ROUTING_VERSION
, OP.OPRN_ID AS OPERATION_ID
, OP.OPRN_NO AS OPERATION_NUMBER
, OP.OPRN_VERS AS OPERATION_VERSION
, ACTIVELKUP.MEANING AS EFFECTIVE
FROM QC_SPEC_MST QS
, IC_ITEM_MST IM
, FM_FORM_MST FM
, IC_LOTS_MST LO
, GME_BATCH_HEADER PM
, FM_ROUT_HDR RO
, FM_OPRN_MST OP
, FND_LOOKUPS ACTIVELKUP
WHERE QS.ITEM_ID = IM.ITEM_ID
AND QS.FORMULA_ID = FM.FORMULA_ID
AND QS.LOT_ID = LO.LOT_ID(+)
AND QS.ITEM_ID = LO.ITEM_ID(+)
AND QS.BATCH_ID = PM.BATCH_ID
AND QS.ROUTING_ID = RO.ROUTING_ID(+)
AND QS.OPRN_ID = OP.OPRN_ID(+)
AND ACTIVELKUP.LOOKUP_TYPE = 'PMI_ACTIVE'
AND ACTIVELKUP.LOOKUP_CODE = 1
AND (SYSDATE >= QS.FROM_DATE
AND SYSDATE <= QS.TO_DATE) UNION SELECT QS.QC_SPEC_ID AS QUALITY_CONTROL_SPEC_ID
, QS.QCASSY_TYP_ID AS ASSAY_TYPE_ID
, QS.ORGN_CODE AS ORGANIZATION_CODE
, QS.WHSE_CODE AS WAREHOUSE_CODE
, QS.LOCATION AS LOCATION
, QS.DOC_TYPE AS DOCUMENT_TYPE
, QS.VENDOR_SPECIFICATION AS VENDOR_SPECIFICATION
, QS.VENDOR_CERTIFICATION AS VENDOR_CERTIFICATION
, QS.CUST_SPECIFICATION AS CUSTOMER_SPECIFICATION
, QS.CUST_CERTIFICATION AS CUSTOMER_CERTIFICATION
, QS.ASSAY_CODE AS ASSAY_CODE
, QS.TEXT_SPEC AS TEXT_SPEC
, QS.MIN_SPEC AS MIN_SPEC
, QS.MAX_SPEC AS MAX_SPEC
, QS.TARGET_SPEC AS TARGET_SPEC
, QS.QCUNIT_CODE AS QUALITY_CONTROL_UNIT_CODE
, QS.FROM_DATE AS FROM_DATE
, QS.TO_DATE AS TO_DATE
, QS.OUTACTION_CODE AS OUT_OF_ACTION_CODE
, QS.OUTACTION_INTERVAL AS OUT_OF_ACTION_INTERVAL
, QS.PREFERENCE AS PREFERENCE
, QS.PRINT_COA_SHIPPED AS PRINT_COA_SHIPPED
, QS.PRINT_COA_INVOICED AS PRINT_COA_INVOICED
, QS.VENDOR_COA_REQUIRED AS VENDOR_COA_REQUIRED
, QS.DELETE_MARK AS DELETE_MARK
, QS.ROUTINGSTEP_NO AS ROUTING_STEP_NUMBER
, ' ' AS CUSTOMER_NUMBER
, ' ' AS CUSTOMER_NAME
, IM.ITEM_NO AS ITEM_NUMBER
, IM.ITEM_DESC1 AS ITEM_DESCRIPTION
, 0 AS VENDOR_ID
, ' ' AS VENDOR_NUMBER
, ' ' AS VENDOR_NAME
, FM.FORMULA_ID AS FORMULA_ID
, FM.FORMULA_NO AS FORMULA_NUMBER
, FM.FORMULA_VERS AS FORMULA_VERSION
, LO.LOT_NO AS LOT_NUMBER
, LO.SUBLOT_NO AS SUB_LOT_NUMBER
, PM.BATCH_NO AS BATCH_NUMBER
, RO.ROUTING_ID AS ROUTING_ID
, RO.ROUTING_NO AS ROUTING_NUMBER
, RO.ROUTING_VERS AS ROUTING_VERSION
, OP.OPRN_ID AS OPERATION_ID
, OP.OPRN_NO AS OPERATION_NUMBER
, OP.OPRN_VERS AS OPERATION_VERSION
, ACTIVELKUP.MEANING AS EFFECTIVE
FROM QC_SPEC_MST QS
, IC_ITEM_MST IM
, FM_FORM_MST FM
, IC_LOTS_MST LO
, GME_BATCH_HEADER PM
, FM_ROUT_HDR RO
, FM_OPRN_MST OP
, FND_LOOKUPS ACTIVELKUP
WHERE QS.ITEM_ID = IM.ITEM_ID
AND QS.FORMULA_ID = FM.FORMULA_ID
AND QS.LOT_ID = LO.LOT_ID(+)
AND QS.ITEM_ID = LO.ITEM_ID(+)
AND QS.BATCH_ID = PM.BATCH_ID
AND QS.ROUTING_ID = RO.ROUTING_ID(+)
AND QS.OPRN_ID = OP.OPRN_ID(+)
AND ACTIVELKUP.LOOKUP_TYPE = 'PMI_ACTIVE'
AND ACTIVELKUP.LOOKUP_CODE = 2
AND ( SYSDATE < QS.FROM_DATE OR SYSDATE > QS.TO_DATE)