148: g_trx_date,
149: g_trx_type_id
150: FROM
151: ZX_LINES_DET_FACTORS ZX_DET_FACT ,
152: ZX_USER_PROC_INPUT_V ZX_PRE_REC_OPT
153: WHERE
154: ZX_DET_FACT.INTERNAL_ORGANIZATION_ID = ZX_PRE_REC_OPT.INTERNAL_ORGANIZATION_ID
155: AND ZX_DET_FACT.APPLICATION_ID = ZX_PRE_REC_OPT.APPLICATION_ID
156: AND ZX_DET_FACT.EVENT_CLASS_CODE = ZX_PRE_REC_OPT.EVENT_CLASS_CODE
346: ZX_LINE_DET_FACT.SHIP_THIRD_PTY_ACCT_SITE_ID ,
347: ZX_LINE_DET_FACT.BILL_THIRD_PTY_ACCT_SITE_ID
348: FROM
349: ZX_LINES_DET_FACTORS ZX_LINE_DET_FACT ,
350: ZX_USER_PROC_INPUT_V ZUPI ,
351: ZX_TRX_PRE_PROC_OPTIONS_GT ZTPPO
352: WHERE
353: ZX_LINE_DET_FACT.INTERNAL_ORGANIZATION_ID = ZUPI.INTERNAL_ORGANIZATION_ID
354: AND ZX_LINE_DET_FACT.APPLICATION_ID = ZUPI.APPLICATION_ID