no puedo insert a mi tabla
Publicado por juan (2 intervenciones) el 21/11/2014 17:20:52
%SelectInit(HR_ACCTG_LN_AET.RUN_DT,HR_ACCTG_LN_AET.SEQNUM,HR_ACCTG_LN_AET.LINE_NBR, HR_ACCTG_LN_AET.BUSINESS_UNIT_GL, HR_ACCTG_LN_AET.ACCOUNT, HR_ACCTG_LN_AET.DEPTID, HR_ACCTG_LN_AET.OPERATING_UNIT, HR_ACCTG_LN_AET.CHARTFIELD1, HR_ACCTG_LN_AET.CHARTFIELD2, HR_ACCTG_LN_AET.APPL_JRNL_ID, HR_ACCTG_LN_AET.MONETARY_AMOUNT)
SELECT %CurrentDateIn AS RUN_DT
,(
SELECT MAX(SEQNUM)+1
FROM %Table(HR_ACCTG_LINE)
WHERE RUN_DT=%CurrentDateIn
AND APPL_JRNL_ID<> %Bind(APPL_JRNL_ID)) ,ROW_NUMBER() OVER(
ORDER BY ACCOUNT DESC) AS LINE_NBR , (
SELECT BU.BUSINESS_UNIT_GL
FROM %Table(COMPANY_TBL) C INNER JOIN %Table(BUS_UNIT_TBL_HR) BU ON BU.DEFAULT_SETID = C.DEFAULT_SETID
WHERE C.COMPANY = %Bind(UCS_HR_GL_AET.COMPANY)
AND C.DEFAULT_SETID =%Bind(SETID)
AND BU.BUSINESS_UNIT = %Bind(BUSINESS_UNIT)), ACCOUNT, DEPTID, OPERATING_UNIT, DEPTID, EMPLID, %Bind(APPL_JRNL_ID), ROUND(SUM(GE_MONT_DIST_EMPL), 2)
FROM PS_%Bind(UCS_HR_GL_AET.RECNAME, NOQUOTES, STATIC) HG
WHERE HG.BUSINESS_UNIT = %Bind(BUSINESS_UNIT)
AND HG.PAY_ENTITY = %Bind(PAY_ENTITY)
AND HG.CAL_PRD_ID = %Bind(CAL_PRD_ID)
AND HG.RUN_TYPE = %Bind(RUN_TYPE)
AND HG.CAL_RUN_ID = %Bind(CAL_RUN_ID)
GROUP BY HG.ACCOUNT, HG.DEPTID, HG.OPERATING_UNIT,HG.EMPLID
SELECT %CurrentDateIn AS RUN_DT
,(
SELECT MAX(SEQNUM)+1
FROM %Table(HR_ACCTG_LINE)
WHERE RUN_DT=%CurrentDateIn
AND APPL_JRNL_ID<> %Bind(APPL_JRNL_ID)) ,ROW_NUMBER() OVER(
ORDER BY ACCOUNT DESC) AS LINE_NBR , (
SELECT BU.BUSINESS_UNIT_GL
FROM %Table(COMPANY_TBL) C INNER JOIN %Table(BUS_UNIT_TBL_HR) BU ON BU.DEFAULT_SETID = C.DEFAULT_SETID
WHERE C.COMPANY = %Bind(UCS_HR_GL_AET.COMPANY)
AND C.DEFAULT_SETID =%Bind(SETID)
AND BU.BUSINESS_UNIT = %Bind(BUSINESS_UNIT)), ACCOUNT, DEPTID, OPERATING_UNIT, DEPTID, EMPLID, %Bind(APPL_JRNL_ID), ROUND(SUM(GE_MONT_DIST_EMPL), 2)
FROM PS_%Bind(UCS_HR_GL_AET.RECNAME, NOQUOTES, STATIC) HG
WHERE HG.BUSINESS_UNIT = %Bind(BUSINESS_UNIT)
AND HG.PAY_ENTITY = %Bind(PAY_ENTITY)
AND HG.CAL_PRD_ID = %Bind(CAL_PRD_ID)
AND HG.RUN_TYPE = %Bind(RUN_TYPE)
AND HG.CAL_RUN_ID = %Bind(CAL_RUN_ID)
GROUP BY HG.ACCOUNT, HG.DEPTID, HG.OPERATING_UNIT,HG.EMPLID
Valora esta pregunta
-1
