ZX_LINES_DET_FACTORS hz_cust_accounts BILL_THIRD_PTY_ACCT_ID ZX_LINES_DET_FACTORS zx_evnt_cls_mappings EVENT_CLASS_MAPPING_ID ZX_LINES_DET_FACTORS ap_tax_codes_all HISTORICAL_TAX_CODE_ID ZX_LINES_DET_FACTORS hz_locations SHIP_TO_LOCATION_ID ZX_LINES_DET_FACTORS hz_locations SHIP_FROM_LO...
ZX_LINES_DET_FACTORS_PK LINES_DET_FACTOR_ID Columns NameDatatypeLengthPrecisionNot-nullCommentsStatus INTERNAL_ORGANIZATION_ID NUMBER Yes Internal organization identifier of the transaction Active ACKNOWLEDGEMENT_NUMBER VARCHAR2 30 Acknowledgement number provided after tax data has been loaded INVOICE_TYPE...
Error: A mandatory constraint to generate unique record in ZX_LINES_DET_FACTORS is violated with error code ORA-00001. Please generate FND Debug Log and APList of the invoice and log a Service RequestError msg: Error: A mandatory constraint to generate unique record in ZX_LINES_DET_FACTORS ...
ZX_DET_FACT.RECEIVABLES_TRX_TYPE_SEQ_ID RECEIVABLES_TRX_TYPE_SEQ_ID FROM ZX_LINES_DET_FACTORS ZX_DET_FACT , ZX_TRX_PRE_PROC_OPTIONS_GT ZX_PRE_REC_OPT WHERE ZX_DET_FACT.INTERNAL_ORGANIZATION_ID = ZX_PRE_REC_OPT.INTERNAL_ORGANIZATION_ID AND ZX_DET_FACT.APPLICATION_ID = ZX_PRE_REC_OP...
zx_lines_det_factors zldf, zx_trx_pre_proc_options_gt ztppo, zx_prvdr_hdr_extns_gt zpshea WHERE zldf.application_id = ztppo.application_id AND zldf.entity_code = ztppo.entity_code AND zldf.event_class_code = ztppo.event_class_code AND zldf.trx_id = ztppo.trx_id AND zpshea...
FROM ZX_LINES_DET_FACTORS zldf, ZX_TRX_PRE_PROC_OPTIONS_GT ztppo, ZX_PRVDR_LINE_EXTNS_GT zpslea WHERE zldf.application_id = ztppo.application_id AND zldf.entity_code = ztppo.entity_code AND zldf.event_class_code = ztppo.event_class_code AND zldf.trx_id = ztppo.trx_id AND ...
ZX_DET_FACT.RECEIVABLES_TRX_TYPE_SEQ_ID Trx_Type_seq_Id FROM ZX_LINES_DET_FACTORS ZX_DET_FACT , ZX_TRX_PRE_PROC_OPTIONS_GT ZX_PRE_REC_OPT WHERE ZX_DET_FACT.INTERNAL_ORGANIZATION_ID = ZX_PRE_REC_OPT.INTERNAL_ORGANIZATION_ID AND ZX_DET_FACT.APPLICATION_ID = ZX_PRE_REC_OPT.APPLICATIO...
Details Schema: FUSION Object owner: ZX Object type: VIEW Columns Name Query SQL_Statement
ZX_LINES_DET_FACTORS_PK LINES_DET_FACTOR_ID Columns NameDatatypeLengthPrecisionNot-nullCommentsStatus INTERNAL_ORGANIZATION_ID NUMBER Yes Internal organization identifier of the transaction Active ACKNOWLEDGEMENT_NUMBER VARCHAR2 30 Acknowledgement number provided after tax data has been loaded INVOICE_TYPE...
ZX_EVNT_CLS_MAPPINGSzx_det_factor_templ_bDET_FACTOR_TEMPL_CODE zx_event_class_paramszx_evnt_cls_mappingsEVENT_CLASS_MAPPING_ID zx_lines_det_factorszx_evnt_cls_mappingsEVENT_CLASS_MAPPING_ID zx_evnt_typ_mappingszx_evnt_cls_mappingsEVENT_CLASS_MAPPING_ID ...