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_SPECIFICATIONS_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, coalkup.meaning AS vendor_coa_required, QS.delete_mark AS delete_mark, QS.routingstep_no as routing_step_number, party.PARTY_NUMBER AS customer_number, party.PARTY_name AS customer_name, IM.item_no AS item_number, IM.item_desc1 AS item_description, V.vendor_id AS vendor_id, V.vendor_no AS vendor_number, V.vendor_name AS vendor_name, ' ' as formula_number, 0 as formula_version, lo.lot_no AS lot_number, lo.sublot_no AS sub_lot_number, '0' AS batch_number, '0' AS routing_number, 1 as routing_version, '0' AS operation_number, 1 AS operation_version, activelkup.meaning as effective, qs.CUST_ID, qs.SHIP_TO_SITE_ID FROM qc_spec_mst QS, hz_cust_accounts_all cust_acct, hz_parties party , ic_item_mst IM, po_vend_mst V, ic_lots_mst lo, FND_LOOKUPS coalkup , FND_LOOKUPS activelkup WHERE party.party_id(+) = cust_acct.party_id and cust_acct.cust_account_id(+) = QS.cust_id AND lo.lot_id(+) = QS.lot_id AND lo.item_id(+) = QS.item_id AND IM.item_id(+) = QS.item_id AND V.vendor_id(+) = QS.vendor_id AND coalkup.lookup_type = 'PMI_YES_NO' AND coalkup.lookup_code = nvl(QS.vendor_coa_required,0) AND activelkup.lookup_type = 'PMI_ACTIVE' AND activelkup.lookup_code = 1 AND (TRUNC(sysdate) >= TRUNC(qs.from_date) and TRUNC(sysdate) < TRUNC(qs.to_date)) UNION SELECT QS.qc_spec_id AS quality_contorl_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, coalkup.meaning AS vendor_coa_required, QS.delete_mark AS delete_mark, QS.routingstep_no as routing_step_number, party.PARTY_NUMBER AS customer_number, party.PARTY_name AS customer_name, IM.item_no AS item_number, IM.item_desc1 AS item_description, V.vendor_id AS vendor_id, V.vendor_no AS vendor_number, V.vendor_name AS vendor_name, ' ' as formula_number, 0 as formula_version, lo.lot_no AS lot_number, lo.sublot_no AS sub_lot_number, ' ' AS batch_number, '0' AS routing_number, 0 as routing_version, '0' AS operation_number, 0 AS operation_version, activelkup.meaning as effective, qs.CUST_ID, qs.SHIP_TO_SITE_ID FROM qc_spec_mst QS, hz_cust_accounts_all cust_acct, hz_parties party , ic_item_mst IM, po_vend_mst V, ic_lots_mst lo, FND_LOOKUPS coalkup , FND_LOOKUPS activelkup WHERE party.party_id(+) = cust_acct.party_id and cust_acct.cust_account_id(+) = QS.cust_id AND lo.lot_id(+) = QS.lot_id AND lo.item_id(+) = QS.item_id AND IM.item_id(+) = QS.item_id AND V.vendor_id(+) = QS.vendor_id AND coalkup.lookup_type = 'PMI_YES_NO' AND coalkup.lookup_code = nvl(QS.vendor_coa_required,0) AND activelkup.lookup_type = 'PMI_ACTIVE' AND activelkup.lookup_code = 2 AND ( TRUNC(sysdate) < TRUNC(qs.from_date) OR TRUNC(sysdate) >= TRUNC(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
, COALKUP.MEANING AS VENDOR_COA_REQUIRED
, QS.DELETE_MARK AS DELETE_MARK
, QS.ROUTINGSTEP_NO AS ROUTING_STEP_NUMBER
, PARTY.PARTY_NUMBER AS CUSTOMER_NUMBER
, PARTY.PARTY_NAME AS CUSTOMER_NAME
, IM.ITEM_NO AS ITEM_NUMBER
, IM.ITEM_DESC1 AS ITEM_DESCRIPTION
, V.VENDOR_ID AS VENDOR_ID
, V.VENDOR_NO AS VENDOR_NUMBER
, V.VENDOR_NAME AS VENDOR_NAME
, ' ' AS FORMULA_NUMBER
, 0 AS FORMULA_VERSION
, LO.LOT_NO AS LOT_NUMBER
, LO.SUBLOT_NO AS SUB_LOT_NUMBER
, '0' AS BATCH_NUMBER
, '0' AS ROUTING_NUMBER
, 1 AS ROUTING_VERSION
, '0' AS OPERATION_NUMBER
, 1 AS OPERATION_VERSION
, ACTIVELKUP.MEANING AS EFFECTIVE
, QS.CUST_ID
, QS.SHIP_TO_SITE_ID
FROM QC_SPEC_MST QS
, HZ_CUST_ACCOUNTS_ALL CUST_ACCT
, HZ_PARTIES PARTY
, IC_ITEM_MST IM
, PO_VEND_MST V
, IC_LOTS_MST LO
, FND_LOOKUPS COALKUP
, FND_LOOKUPS ACTIVELKUP
WHERE PARTY.PARTY_ID(+) = CUST_ACCT.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID(+) = QS.CUST_ID
AND LO.LOT_ID(+) = QS.LOT_ID
AND LO.ITEM_ID(+) = QS.ITEM_ID
AND IM.ITEM_ID(+) = QS.ITEM_ID
AND V.VENDOR_ID(+) = QS.VENDOR_ID
AND COALKUP.LOOKUP_TYPE = 'PMI_YES_NO'
AND COALKUP.LOOKUP_CODE = NVL(QS.VENDOR_COA_REQUIRED
, 0)
AND ACTIVELKUP.LOOKUP_TYPE = 'PMI_ACTIVE'
AND ACTIVELKUP.LOOKUP_CODE = 1
AND (TRUNC(SYSDATE) >= TRUNC(QS.FROM_DATE)
AND TRUNC(SYSDATE) < TRUNC(QS.TO_DATE)) UNION SELECT QS.QC_SPEC_ID AS QUALITY_CONTORL_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
, COALKUP.MEANING AS VENDOR_COA_REQUIRED
, QS.DELETE_MARK AS DELETE_MARK
, QS.ROUTINGSTEP_NO AS ROUTING_STEP_NUMBER
, PARTY.PARTY_NUMBER AS CUSTOMER_NUMBER
, PARTY.PARTY_NAME AS CUSTOMER_NAME
, IM.ITEM_NO AS ITEM_NUMBER
, IM.ITEM_DESC1 AS ITEM_DESCRIPTION
, V.VENDOR_ID AS VENDOR_ID
, V.VENDOR_NO AS VENDOR_NUMBER
, V.VENDOR_NAME AS VENDOR_NAME
, ' ' AS FORMULA_NUMBER
, 0 AS FORMULA_VERSION
, LO.LOT_NO AS LOT_NUMBER
, LO.SUBLOT_NO AS SUB_LOT_NUMBER
, ' ' AS BATCH_NUMBER
, '0' AS ROUTING_NUMBER
, 0 AS ROUTING_VERSION
, '0' AS OPERATION_NUMBER
, 0 AS OPERATION_VERSION
, ACTIVELKUP.MEANING AS EFFECTIVE
, QS.CUST_ID
, QS.SHIP_TO_SITE_ID
FROM QC_SPEC_MST QS
, HZ_CUST_ACCOUNTS_ALL CUST_ACCT
, HZ_PARTIES PARTY
, IC_ITEM_MST IM
, PO_VEND_MST V
, IC_LOTS_MST LO
, FND_LOOKUPS COALKUP
, FND_LOOKUPS ACTIVELKUP
WHERE PARTY.PARTY_ID(+) = CUST_ACCT.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID(+) = QS.CUST_ID
AND LO.LOT_ID(+) = QS.LOT_ID
AND LO.ITEM_ID(+) = QS.ITEM_ID
AND IM.ITEM_ID(+) = QS.ITEM_ID
AND V.VENDOR_ID(+) = QS.VENDOR_ID
AND COALKUP.LOOKUP_TYPE = 'PMI_YES_NO'
AND COALKUP.LOOKUP_CODE = NVL(QS.VENDOR_COA_REQUIRED
, 0)
AND ACTIVELKUP.LOOKUP_TYPE = 'PMI_ACTIVE'
AND ACTIVELKUP.LOOKUP_CODE = 2
AND ( TRUNC(SYSDATE) < TRUNC(QS.FROM_DATE) OR TRUNC(SYSDATE) >= TRUNC(QS.TO_DATE))