APPS.OKS_IMPORT_VALIDATE dependencies on OKS_SALES_CREDITS_INTERFACE

Line 5219: ,'OKS_SALES_CREDITS_INTERFACE'

5215: ,ERROR_MSG
5216: ,MSG_TOKENS)
5217: VALUES (G_WORKER_REQ_ID
5218: ,HEADER_INTERFACE_ROWID
5219: ,'OKS_SALES_CREDITS_INTERFACE'
5220: ,SALES_CREDIT_INTERFACE_ID
5221: ,'OKS_IMP_SC_INVALID_SALEPERS'
5222: ,NULL)
5223: WHEN (SALESGROUP_V = 'N') THEN

Line 5233: ,'OKS_SALES_CREDITS_INTERFACE'

5229: ,ERROR_MSG
5230: ,MSG_TOKENS)
5231: VALUES (G_WORKER_REQ_ID
5232: ,HEADER_INTERFACE_ROWID
5233: ,'OKS_SALES_CREDITS_INTERFACE'
5234: ,SALES_CREDIT_INTERFACE_ID
5235: ,'OKS_IMP_SC_INVALID_SALEGRP'
5236: ,NULL)
5237: WHEN (SALES_CREDIT_TYPE_ID IS NULL) THEN

Line 5247: ,'OKS_SALES_CREDITS_INTERFACE'

5243: ,ERROR_MSG
5244: ,MSG_TOKENS)
5245: VALUES (G_WORKER_REQ_ID
5246: ,HEADER_INTERFACE_ROWID
5247: ,'OKS_SALES_CREDITS_INTERFACE'
5248: ,SALES_CREDIT_INTERFACE_ID
5249: ,'OKS_IMP_SC_INVALID_SCT'
5250: ,NULL)
5251: WHEN (QUOTA_FLAG = 'Y' AND PERCENT_SUM <> 100) THEN

Line 5261: ,'OKS_SALES_CREDITS_INTERFACE'

5257: ,ERROR_MSG
5258: ,MSG_TOKENS)
5259: VALUES (G_WORKER_REQ_ID
5260: ,HEADER_INTERFACE_ROWID
5261: ,'OKS_SALES_CREDITS_INTERFACE'
5262: ,SALES_CREDIT_INTERFACE_ID
5263: ,'OKS_IMP_SC_INVALID_PERSUM'
5264: ,NULL)
5265: WHEN (PERCENT IS NULL OR PERCENT < 0 OR PERCENT > 100) THEN

Line 5275: ,'OKS_SALES_CREDITS_INTERFACE'

5271: ,ERROR_MSG
5272: ,MSG_TOKENS)
5273: VALUES (G_WORKER_REQ_ID
5274: ,HEADER_INTERFACE_ROWID
5275: ,'OKS_SALES_CREDITS_INTERFACE'
5276: ,SALES_CREDIT_INTERFACE_ID
5277: ,'OKS_IMP_SC_INVALID_PER'
5278: ,NULL)
5279: WHEN (UNIQ = 'N') THEN

Line 5289: ,'OKS_SALES_CREDITS_INTERFACE'

5285: ,ERROR_MSG
5286: ,MSG_TOKENS)
5287: VALUES (G_WORKER_REQ_ID
5288: ,HEADER_INTERFACE_ROWID
5289: ,'OKS_SALES_CREDITS_INTERFACE'
5290: ,SALES_CREDIT_INTERFACE_ID
5291: ,'OKS_IMP_SC_SP_SCT_NUNIQ'
5292: ,NULL)
5293: SELECT OSC.SALES_CREDIT_INTERFACE_ID SALES_CREDIT_INTERFACE_ID

Line 5317: ,(CASE WHEN EXISTS (SELECT 'X' FROM OKS_SALES_CREDITS_INTERFACE

5313: ,(CASE WHEN COUNT(DISTINCT SCT.ROWID) OVER (PARTITION BY OSC.ROWID) = 1
5314: THEN MAX(SCT.QUOTA_FLAG) OVER (PARTITION BY OSC.ROWID) ELSE NULL END) QUOTA_FLAG
5315: , SUM(OSC.PERCENT) OVER (PARTITION BY OSC.HEADER_INTERFACE_ID, SCT.QUOTA_FLAG) PERCENT_SUM
5316: , OSC.PERCENT PERCENT
5317: ,(CASE WHEN EXISTS (SELECT 'X' FROM OKS_SALES_CREDITS_INTERFACE
5318: WHERE SALES_CREDIT_INTERFACE_ID <> OSC.SALES_CREDIT_INTERFACE_ID
5319: AND HEADER_INTERFACE_ID = OSC.HEADER_INTERFACE_ID
5320: AND (SALESPERSON_ID = OSC.SALESPERSON_ID OR SALESPERSON_NAME = OSC.SALESPERSON_NAME)
5321: AND SALES_CREDIT_TYPE = OSC.SALES_CREDIT_TYPE)

Line 5323: FROM OKS_SALES_CREDITS_INTERFACE OSC

5319: AND HEADER_INTERFACE_ID = OSC.HEADER_INTERFACE_ID
5320: AND (SALESPERSON_ID = OSC.SALESPERSON_ID OR SALESPERSON_NAME = OSC.SALESPERSON_NAME)
5321: AND SALES_CREDIT_TYPE = OSC.SALES_CREDIT_TYPE)
5322: THEN 'N' ELSE 'Y' END) UNIQ
5323: FROM OKS_SALES_CREDITS_INTERFACE OSC
5324: ,OKS_INT_HEADER_STG_TEMP HDR
5325: ,OE_SALES_CREDIT_TYPES SCT
5326: ,(SELECT distinct(OSCI.SALES_CREDIT_INTERFACE_ID) -- to avoid duplicate joins with tables when some names match with multiple records
5327: ,(CASE WHEN COUNT(DISTINCT SPI.ROWID) OVER (PARTITION BY OSCI.ROW_ID) = 1

Line 5335: FROM OKS_SALES_CREDITS_INTERFACE SCI, OKS_INT_HEADER_STG_TEMP HST

5331: ELSE NULL
5332: END) SALESPERSON_ID
5333: FROM (SELECT SCI.ROWID ROW_ID, SCI.SALES_CREDIT_INTERFACE_ID, SCI.SALESPERSON_NAME, SCI.SALESPERSON_ID,
5334: SCI.SALESGROUP_ID, SCI.SALES_CREDIT_TYPE, SCI.PERCENT, HST.OPERATING_UNIT_ID
5335: FROM OKS_SALES_CREDITS_INTERFACE SCI, OKS_INT_HEADER_STG_TEMP HST
5336: WHERE SCI.HEADER_INTERFACE_ID = HST.HEADER_INTERFACE_ID) OSCI
5337: ,JTF_RS_SALESREPS SPI
5338: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
5339: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP

Line 5352: SELECT count(1) INTO l_int_count FROM OKS_SALES_CREDITS_INTERFACE OSCI

5348: AND OSC.SALES_CREDIT_TYPE = SCT.NAME (+);
5349:
5350: IF G_STMT_LOG THEN
5351:
5352: SELECT count(1) INTO l_int_count FROM OKS_SALES_CREDITS_INTERFACE OSCI
5353: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
5354: WHERE HEADER_INTERFACE_ID = OSCI.HEADER_INTERFACE_ID);
5355:
5356: SELECT count(1) INTO l_stg_count FROM OKS_INT_SALES_CREDIT_STG_TEMP;