VIEW: APPS.OKS_AUTH_SHOWALL_PROD_V

Source

View Text - Preformatted

SELECT TO_NUMBER(KLIN.LINE_NUMBER) LINE_NUMBER , KLIN.START_DATE , KLIN.END_DATE , OKS_EXTWAR_UTIL_PVT.Round_Currency_Amt(KLIN.PRICE_NEGOTIATED,KHDR.CURRENCY_CODE) FINAL_PRICE , KLIN.ID LINE_ID , KLIN.CLE_ID PARENT_LINE_ID , DECODE(FND_PROFILE.VALUE('OKS_ITEM_DISPLAY_PREFERENCE'),'DISPLAY_NAME',MSI.CONCATENATED_SEGMENTS,MSI.DESCRIPTION) PRODUCT_NAME , CP.SERIAL_NUMBER CURRENT_SERIAL_NUMBER , decode(cp.INSTALL_LOCATION_TYPE_CODE,'HZ_PARTY_SITES',(select ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,HZ.ADDRESS1,HZ.ADDRESS2,HZ.ADDRESS3, HZ.ADDRESS4,HZ.CITY,HZ.COUNTY,HZ.STATE,HZ.PROVINCE,HZ.POSTAL_CODE,NULL,HZ.COUNTRY,NULL, NULL,NULL,NULL,NULL,NULL,NULL,'N','N',300,1,1) from hz_locations hz,hz_party_sites hps WHERE hz.location_id = hps.location_id and hps.party_site_id = cp.location_id), 'HZ_LOCATIONS',(select address1 from hz_locations hz where hz.location_id = cp.location_id), 'VENDOR_SITE',(select address_line1 from po_vendor_sites_all pvs where pvs.vendor_site_id = cp.location_id), 'INVENTORY',(select address_line_1 from hr_locations_all hrl where hrl.location_id = cp.location_id), 'INTERNAL_SITE',(select address_line_1 from hr_locations_all hrl where hrl.location_id = cp.location_id), 'WIP',(select address1 from hz_locations hz where hz.location_id = cp.location_id), 'PROJECT',(select address1 from hz_locations hz where hz.location_id = cp.location_id), 'IN_TRANSIT',(select address1 from hz_locations hz where hz.location_id = cp.location_id), 'PO',(select address1 from hz_locations hz where hz.location_id = cp.location_id) ) ADDRESS , CP.INSTALL_DATE INSTALLATION_DATE , CP.QUANTITY QUANTITY , UOM.UNIT_OF_MEASURE UOM_CODE , CP.INSTANCE_NUMBER REFERENCE_NUMBER , OOL.UNIT_SELLING_PRICE NET_AMOUNT , CP.INSTANCE_ID customer_product_id , S.NAME SYSTEM_NAME , decode(cp.owner_party_source_table,'HZ_PARTIES',(select hz.party_name from hz_parties hz, hz_cust_accounts_all hzacct where hz.party_id = cp.owner_party_id and hz.party_id = hzacct.party_id and hzacct.cust_account_id = cp.owner_party_account_id), 'PO_VENDORS',(select vendor_name from po_vendors pv where pv.vendor_id = cp.owner_party_id), 'EMPLOYEE',(select full_name from per_all_people_f em where em.person_id = cp.owner_party_id), 'TEAM',(select team_name from jtf_rs_teams_vl tm where tm.team_id = cp.owner_party_id), 'GROUP',(select group_name from jtf_rs_groups_vl gr where gr.group_id = cp.owner_party_id) ) CUSTOMER_NAME , CP.EXTERNAL_REFERENCE EXTERNAL_REFERENCE , decode(cp.LOCATION_TYPE_CODE,'HZ_PARTY_SITES',(select address1 from hz_locations hz,hz_party_sites hps where hz.location_id = hps.location_id and hps.party_site_id = cp.location_id), 'HZ_LOCATIONS',(select address1 from hz_locations hz where hz.location_id = cp.location_id), 'VENDOR_SITE',(select address_line1 from po_vendor_sites_all pvs where pvs.vendor_site_id = cp.location_id), 'INVENTORY',(select address_line_1 from hr_locations_all hrl where hrl.location_id = cp.location_id), 'INTERNAL_SITE',(select address_line_1 from hr_locations_all hrl where hrl.location_id = cp.location_id), 'WIP',(select address1 from hz_locations hz where hz.location_id = cp.location_id), 'PROJECT',(select address1 from hz_locations hz where hz.location_id = cp.location_id), 'IN_TRANSIT',(select address1 from hz_locations hz where hz.location_id = cp.location_id), 'PO',(select address1 from hz_locations hz where hz.location_id = cp.location_id) ) CURRENT_LOCATION , OOH.ORDER_NUMBER ORDER_NUMBER , CPA.PRICING_attribute1 , CPA.PRICING_attribute2 , CPA.PRICING_attribute3 , CPA.PRICING_attribute4 , CPA.PRICING_ATTRIBUTE5 , CPA.PRICING_ATTRIBUTE6 , CPA.PRICING_ATTRIBUTE7 , CPA.PRICING_ATTRIBUTE8 , CPA.PRICING_ATTRIBUTE9 , CPA.PRICING_ATTRIBUTE10 , CPA.PRICING_ATTRIBUTE11 , CPA.PRICING_ATTRIBUTE12 , CPA.PRICING_ATTRIBUTE13 , CPA.PRICING_ATTRIBUTE14 , CPA.PRICING_ATTRIBUTE15 , CPA.PRICING_ATTRIBUTE16 , CPA.PRICING_ATTRIBUTE17 , CPA.PRICING_ATTRIBUTE18 , CPA.PRICING_ATTRIBUTE19 , CPA.PRICING_ATTRIBUTE20 , CPA.PRICING_ATTRIBUTE21 , CPA.PRICING_ATTRIBUTE22 , CPA.PRICING_ATTRIBUTE23 , CPA.PRICING_ATTRIBUTE24 , CPA.PRICING_ATTRIBUTE25 , CPA.PRICING_ATTRIBUTE26 , CPA.PRICING_ATTRIBUTE27 , CPA.PRICING_ATTRIBUTE28 , CPA.PRICING_ATTRIBUTE29 , CPA.PRICING_ATTRIBUTE30 , CPA.PRICING_ATTRIBUTE31 , CPA.PRICING_ATTRIBUTE32 , CPA.PRICING_ATTRIBUTE33 , CPA.PRICING_ATTRIBUTE34 , CPA.PRICING_ATTRIBUTE35 , CPA.PRICING_ATTRIBUTE36 , CPA.PRICING_ATTRIBUTE37 , CPA.PRICING_ATTRIBUTE38 , CPA.PRICING_ATTRIBUTE39 , CPA.PRICING_ATTRIBUTE40 , CPA.PRICING_ATTRIBUTE41 , CPA.PRICING_ATTRIBUTE42 , CPA.PRICING_ATTRIBUTE43 , CPA.PRICING_ATTRIBUTE44 , CPA.PRICING_ATTRIBUTE45 , CPA.PRICING_ATTRIBUTE46 , CPA.PRICING_ATTRIBUTE47 , CPA.PRICING_ATTRIBUTE48 , CPA.PRICING_ATTRIBUTE49 , CPA.PRICING_ATTRIBUTE50 , CPA.PRICING_ATTRIBUTE51 , CPA.PRICING_ATTRIBUTE52 , CPA.PRICING_ATTRIBUTE53 , CPA.PRICING_ATTRIBUTE54 , CPA.PRICING_ATTRIBUTE55 , CPA.PRICING_ATTRIBUTE56 , CPA.PRICING_ATTRIBUTE57 , CPA.PRICING_ATTRIBUTE58 , CPA.PRICING_ATTRIBUTE59 , CPA.PRICING_ATTRIBUTE60 , CPA.PRICING_ATTRIBUTE61 , CPA.PRICING_ATTRIBUTE62 , CPA.PRICING_ATTRIBUTE63 , CPA.PRICING_ATTRIBUTE64 , CPA.PRICING_ATTRIBUTE65 , CPA.PRICING_ATTRIBUTE66 , CPA.PRICING_ATTRIBUTE67 , CPA.PRICING_ATTRIBUTE68 , CPA.PRICING_ATTRIBUTE69 , CPA.PRICING_ATTRIBUTE70 , CPA.PRICING_ATTRIBUTE71 , CPA.PRICING_ATTRIBUTE72 , CPA.PRICING_ATTRIBUTE73 , CPA.PRICING_ATTRIBUTE74 , CPA.PRICING_ATTRIBUTE75 , CPA.PRICING_ATTRIBUTE76 , CPA.PRICING_ATTRIBUTE77 , CPA.PRICING_ATTRIBUTE78 , CPA.PRICING_ATTRIBUTE79 , CPA.PRICING_ATTRIBUTE80 , CPA.PRICING_ATTRIBUTE81 , CPA.PRICING_ATTRIBUTE82 , CPA.PRICING_ATTRIBUTE83 , CPA.PRICING_ATTRIBUTE84 , CPA.PRICING_ATTRIBUTE85 , CPA.PRICING_ATTRIBUTE86 , CPA.PRICING_ATTRIBUTE87 , CPA.PRICING_ATTRIBUTE88 , CPA.PRICING_ATTRIBUTE89 , CPA.PRICING_ATTRIBUTE90 , CPA.PRICING_ATTRIBUTE91 , CPA.PRICING_ATTRIBUTE92 , CPA.PRICING_ATTRIBUTE93 , CPA.PRICING_ATTRIBUTE94 , CPA.PRICING_ATTRIBUTE95 , CPA.PRICING_ATTRIBUTE96 , CPA.PRICING_ATTRIBUTE97 , CPA.PRICING_ATTRIBUTE98 , CPA.PRICING_ATTRIBUTE99 , CPA.PRICING_ATTRIBUTE100 , CPA.PRICING_context FROM CSI_ITEM_INSTANCES CP , CSI_I_PRICING_ATTRIBS CPA , OE_ORDER_LINES_ALL OOL , OE_ORDER_HEADERS_ALL OOH , CSI_SYSTEMS_VL S , MTL_SYSTEM_ITEMS_KFV MSI , OKC_K_HEADERS_ALL_B KHDR , OKC_K_LINES_B KLIN , OKC_K_ITEMS KITM , MTL_UNITS_OF_MEASURE_TL UOM WHERE cpa.instance_id(+) = CP.instance_id AND CP.SYSTEM_ID = S.SYSTEM_ID(+) AND MSI.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = CP.LAST_VLD_ORGANIZATION_ID AND CP.LAST_OE_ORDER_LINE_ID = OOL.LINE_ID(+) AND OOL.HEADER_ID = OOH.HEADER_ID(+) AND UOM.UOM_CODE = CP.UNIT_OF_MEASURE AND UOM.LANGUAGE = USERENV('LANG') AND KHDR.ID = KLIN.DNZ_CHR_ID AND KLIN.CLE_ID IS NOT NULL AND KLIN.ID = KITM.CLE_ID AND KITM.OBJECT1_ID1 = CP.instance_id AND KITM.OBJECT1_ID2 = '#' AND KITM.JTOT_OBJECT1_CODE = 'OKX_CUSTPROD'

View Text - HTML Formatted

SELECT TO_NUMBER(KLIN.LINE_NUMBER) LINE_NUMBER
, KLIN.START_DATE
, KLIN.END_DATE
, OKS_EXTWAR_UTIL_PVT.ROUND_CURRENCY_AMT(KLIN.PRICE_NEGOTIATED
, KHDR.CURRENCY_CODE) FINAL_PRICE
, KLIN.ID LINE_ID
, KLIN.CLE_ID PARENT_LINE_ID
, DECODE(FND_PROFILE.VALUE('OKS_ITEM_DISPLAY_PREFERENCE')
, 'DISPLAY_NAME'
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION) PRODUCT_NAME
, CP.SERIAL_NUMBER CURRENT_SERIAL_NUMBER
, DECODE(CP.INSTALL_LOCATION_TYPE_CODE
, 'HZ_PARTY_SITES'
, (SELECT ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, HZ.ADDRESS1
, HZ.ADDRESS2
, HZ.ADDRESS3
, HZ.ADDRESS4
, HZ.CITY
, HZ.COUNTY
, HZ.STATE
, HZ.PROVINCE
, HZ.POSTAL_CODE
, NULL
, HZ.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 300
, 1
, 1)
FROM HZ_LOCATIONS HZ
, HZ_PARTY_SITES HPS
WHERE HZ.LOCATION_ID = HPS.LOCATION_ID
AND HPS.PARTY_SITE_ID = CP.LOCATION_ID)
, 'HZ_LOCATIONS'
, (SELECT ADDRESS1
FROM HZ_LOCATIONS HZ
WHERE HZ.LOCATION_ID = CP.LOCATION_ID)
, 'VENDOR_SITE'
, (SELECT ADDRESS_LINE1
FROM PO_VENDOR_SITES_ALL PVS
WHERE PVS.VENDOR_SITE_ID = CP.LOCATION_ID)
, 'INVENTORY'
, (SELECT ADDRESS_LINE_1
FROM HR_LOCATIONS_ALL HRL
WHERE HRL.LOCATION_ID = CP.LOCATION_ID)
, 'INTERNAL_SITE'
, (SELECT ADDRESS_LINE_1
FROM HR_LOCATIONS_ALL HRL
WHERE HRL.LOCATION_ID = CP.LOCATION_ID)
, 'WIP'
, (SELECT ADDRESS1
FROM HZ_LOCATIONS HZ
WHERE HZ.LOCATION_ID = CP.LOCATION_ID)
, 'PROJECT'
, (SELECT ADDRESS1
FROM HZ_LOCATIONS HZ
WHERE HZ.LOCATION_ID = CP.LOCATION_ID)
, 'IN_TRANSIT'
, (SELECT ADDRESS1
FROM HZ_LOCATIONS HZ
WHERE HZ.LOCATION_ID = CP.LOCATION_ID)
, 'PO'
, (SELECT ADDRESS1
FROM HZ_LOCATIONS HZ
WHERE HZ.LOCATION_ID = CP.LOCATION_ID) ) ADDRESS
, CP.INSTALL_DATE INSTALLATION_DATE
, CP.QUANTITY QUANTITY
, UOM.UNIT_OF_MEASURE UOM_CODE
, CP.INSTANCE_NUMBER REFERENCE_NUMBER
, OOL.UNIT_SELLING_PRICE NET_AMOUNT
, CP.INSTANCE_ID CUSTOMER_PRODUCT_ID
, S.NAME SYSTEM_NAME
, DECODE(CP.OWNER_PARTY_SOURCE_TABLE
, 'HZ_PARTIES'
, (SELECT HZ.PARTY_NAME
FROM HZ_PARTIES HZ
, HZ_CUST_ACCOUNTS_ALL HZACCT
WHERE HZ.PARTY_ID = CP.OWNER_PARTY_ID
AND HZ.PARTY_ID = HZACCT.PARTY_ID
AND HZACCT.CUST_ACCOUNT_ID = CP.OWNER_PARTY_ACCOUNT_ID)
, 'PO_VENDORS'
, (SELECT VENDOR_NAME
FROM PO_VENDORS PV
WHERE PV.VENDOR_ID = CP.OWNER_PARTY_ID)
, 'EMPLOYEE'
, (SELECT FULL_NAME
FROM PER_ALL_PEOPLE_F EM
WHERE EM.PERSON_ID = CP.OWNER_PARTY_ID)
, 'TEAM'
, (SELECT TEAM_NAME
FROM JTF_RS_TEAMS_VL TM
WHERE TM.TEAM_ID = CP.OWNER_PARTY_ID)
, 'GROUP'
, (SELECT GROUP_NAME
FROM JTF_RS_GROUPS_VL GR
WHERE GR.GROUP_ID = CP.OWNER_PARTY_ID) ) CUSTOMER_NAME
, CP.EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, DECODE(CP.LOCATION_TYPE_CODE
, 'HZ_PARTY_SITES'
, (SELECT ADDRESS1
FROM HZ_LOCATIONS HZ
, HZ_PARTY_SITES HPS
WHERE HZ.LOCATION_ID = HPS.LOCATION_ID
AND HPS.PARTY_SITE_ID = CP.LOCATION_ID)
, 'HZ_LOCATIONS'
, (SELECT ADDRESS1
FROM HZ_LOCATIONS HZ
WHERE HZ.LOCATION_ID = CP.LOCATION_ID)
, 'VENDOR_SITE'
, (SELECT ADDRESS_LINE1
FROM PO_VENDOR_SITES_ALL PVS
WHERE PVS.VENDOR_SITE_ID = CP.LOCATION_ID)
, 'INVENTORY'
, (SELECT ADDRESS_LINE_1
FROM HR_LOCATIONS_ALL HRL
WHERE HRL.LOCATION_ID = CP.LOCATION_ID)
, 'INTERNAL_SITE'
, (SELECT ADDRESS_LINE_1
FROM HR_LOCATIONS_ALL HRL
WHERE HRL.LOCATION_ID = CP.LOCATION_ID)
, 'WIP'
, (SELECT ADDRESS1
FROM HZ_LOCATIONS HZ
WHERE HZ.LOCATION_ID = CP.LOCATION_ID)
, 'PROJECT'
, (SELECT ADDRESS1
FROM HZ_LOCATIONS HZ
WHERE HZ.LOCATION_ID = CP.LOCATION_ID)
, 'IN_TRANSIT'
, (SELECT ADDRESS1
FROM HZ_LOCATIONS HZ
WHERE HZ.LOCATION_ID = CP.LOCATION_ID)
, 'PO'
, (SELECT ADDRESS1
FROM HZ_LOCATIONS HZ
WHERE HZ.LOCATION_ID = CP.LOCATION_ID) ) CURRENT_LOCATION
, OOH.ORDER_NUMBER ORDER_NUMBER
, CPA.PRICING_ATTRIBUTE1
, CPA.PRICING_ATTRIBUTE2
, CPA.PRICING_ATTRIBUTE3
, CPA.PRICING_ATTRIBUTE4
, CPA.PRICING_ATTRIBUTE5
, CPA.PRICING_ATTRIBUTE6
, CPA.PRICING_ATTRIBUTE7
, CPA.PRICING_ATTRIBUTE8
, CPA.PRICING_ATTRIBUTE9
, CPA.PRICING_ATTRIBUTE10
, CPA.PRICING_ATTRIBUTE11
, CPA.PRICING_ATTRIBUTE12
, CPA.PRICING_ATTRIBUTE13
, CPA.PRICING_ATTRIBUTE14
, CPA.PRICING_ATTRIBUTE15
, CPA.PRICING_ATTRIBUTE16
, CPA.PRICING_ATTRIBUTE17
, CPA.PRICING_ATTRIBUTE18
, CPA.PRICING_ATTRIBUTE19
, CPA.PRICING_ATTRIBUTE20
, CPA.PRICING_ATTRIBUTE21
, CPA.PRICING_ATTRIBUTE22
, CPA.PRICING_ATTRIBUTE23
, CPA.PRICING_ATTRIBUTE24
, CPA.PRICING_ATTRIBUTE25
, CPA.PRICING_ATTRIBUTE26
, CPA.PRICING_ATTRIBUTE27
, CPA.PRICING_ATTRIBUTE28
, CPA.PRICING_ATTRIBUTE29
, CPA.PRICING_ATTRIBUTE30
, CPA.PRICING_ATTRIBUTE31
, CPA.PRICING_ATTRIBUTE32
, CPA.PRICING_ATTRIBUTE33
, CPA.PRICING_ATTRIBUTE34
, CPA.PRICING_ATTRIBUTE35
, CPA.PRICING_ATTRIBUTE36
, CPA.PRICING_ATTRIBUTE37
, CPA.PRICING_ATTRIBUTE38
, CPA.PRICING_ATTRIBUTE39
, CPA.PRICING_ATTRIBUTE40
, CPA.PRICING_ATTRIBUTE41
, CPA.PRICING_ATTRIBUTE42
, CPA.PRICING_ATTRIBUTE43
, CPA.PRICING_ATTRIBUTE44
, CPA.PRICING_ATTRIBUTE45
, CPA.PRICING_ATTRIBUTE46
, CPA.PRICING_ATTRIBUTE47
, CPA.PRICING_ATTRIBUTE48
, CPA.PRICING_ATTRIBUTE49
, CPA.PRICING_ATTRIBUTE50
, CPA.PRICING_ATTRIBUTE51
, CPA.PRICING_ATTRIBUTE52
, CPA.PRICING_ATTRIBUTE53
, CPA.PRICING_ATTRIBUTE54
, CPA.PRICING_ATTRIBUTE55
, CPA.PRICING_ATTRIBUTE56
, CPA.PRICING_ATTRIBUTE57
, CPA.PRICING_ATTRIBUTE58
, CPA.PRICING_ATTRIBUTE59
, CPA.PRICING_ATTRIBUTE60
, CPA.PRICING_ATTRIBUTE61
, CPA.PRICING_ATTRIBUTE62
, CPA.PRICING_ATTRIBUTE63
, CPA.PRICING_ATTRIBUTE64
, CPA.PRICING_ATTRIBUTE65
, CPA.PRICING_ATTRIBUTE66
, CPA.PRICING_ATTRIBUTE67
, CPA.PRICING_ATTRIBUTE68
, CPA.PRICING_ATTRIBUTE69
, CPA.PRICING_ATTRIBUTE70
, CPA.PRICING_ATTRIBUTE71
, CPA.PRICING_ATTRIBUTE72
, CPA.PRICING_ATTRIBUTE73
, CPA.PRICING_ATTRIBUTE74
, CPA.PRICING_ATTRIBUTE75
, CPA.PRICING_ATTRIBUTE76
, CPA.PRICING_ATTRIBUTE77
, CPA.PRICING_ATTRIBUTE78
, CPA.PRICING_ATTRIBUTE79
, CPA.PRICING_ATTRIBUTE80
, CPA.PRICING_ATTRIBUTE81
, CPA.PRICING_ATTRIBUTE82
, CPA.PRICING_ATTRIBUTE83
, CPA.PRICING_ATTRIBUTE84
, CPA.PRICING_ATTRIBUTE85
, CPA.PRICING_ATTRIBUTE86
, CPA.PRICING_ATTRIBUTE87
, CPA.PRICING_ATTRIBUTE88
, CPA.PRICING_ATTRIBUTE89
, CPA.PRICING_ATTRIBUTE90
, CPA.PRICING_ATTRIBUTE91
, CPA.PRICING_ATTRIBUTE92
, CPA.PRICING_ATTRIBUTE93
, CPA.PRICING_ATTRIBUTE94
, CPA.PRICING_ATTRIBUTE95
, CPA.PRICING_ATTRIBUTE96
, CPA.PRICING_ATTRIBUTE97
, CPA.PRICING_ATTRIBUTE98
, CPA.PRICING_ATTRIBUTE99
, CPA.PRICING_ATTRIBUTE100
, CPA.PRICING_CONTEXT
FROM CSI_ITEM_INSTANCES CP
, CSI_I_PRICING_ATTRIBS CPA
, OE_ORDER_LINES_ALL OOL
, OE_ORDER_HEADERS_ALL OOH
, CSI_SYSTEMS_VL S
, MTL_SYSTEM_ITEMS_KFV MSI
, OKC_K_HEADERS_ALL_B KHDR
, OKC_K_LINES_B KLIN
, OKC_K_ITEMS KITM
, MTL_UNITS_OF_MEASURE_TL UOM
WHERE CPA.INSTANCE_ID(+) = CP.INSTANCE_ID
AND CP.SYSTEM_ID = S.SYSTEM_ID(+)
AND MSI.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = CP.LAST_VLD_ORGANIZATION_ID
AND CP.LAST_OE_ORDER_LINE_ID = OOL.LINE_ID(+)
AND OOL.HEADER_ID = OOH.HEADER_ID(+)
AND UOM.UOM_CODE = CP.UNIT_OF_MEASURE
AND UOM.LANGUAGE = USERENV('LANG')
AND KHDR.ID = KLIN.DNZ_CHR_ID
AND KLIN.CLE_ID IS NOT NULL
AND KLIN.ID = KITM.CLE_ID
AND KITM.OBJECT1_ID1 = CP.INSTANCE_ID
AND KITM.OBJECT1_ID2 = '#'
AND KITM.JTOT_OBJECT1_CODE = 'OKX_CUSTPROD'