1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140
|
SELECT CAS.TITRE CAS_TITRE
,CAS.DESIGNATION CAS_DESIGNATION
,CAS.CAS_NUMERO CAS_NUMERO
,BON.DB_ELEMENT_ID BON_DB_ELEMENT_ID
,BON.STATUS BON_STATUS
,BON.ID BON_ID
,BON.DO_LOT_ENT_ID BON_DO_LOT_ENT_ID
,BON.DATE_BON BON_DATE_BON
,BON.BON_NUMERO BON_BON_NUMERO
,BON.BON_SEQUENCE BON_BON_SEQUENCE
,BON.NOM_CLIENT BON_NOM_CLIENT
,BON.NUMERO_CLIENT BON_NUMERO_CLIENT
,BON.INT_TIDENT_CI BON_INT_TIDENT_CI
,BON.INT_IDROLE_ID BON_INT_IDROLE_ID
,BON.NUMERO_CARTE BON_NUMERO_CARTE
,BON.NUMERO_DOSSIER BON_NUMERO_DOSSIER
,BON.SE_CAS_ID BON_SE_CAS_ID
,BON.RECETTE_ARTICLE BON_RECETTE_ARTICLE
,BON.AS_PROD_ID BON_AS_PROD_ID
,BON.AS_PROD_VEHI_ID BON_AS_PROD_VEHI_ID
,BON.QUANTITE BON_QUANTITE
,BON.PRIX_UNITAIRE BON_PRIX_UNITAIRE
,BON.TAUX_RABAIS BON_TAUX_RABAIS
,BON.MONTANT_RABAIS BON_MONTANT_RABAIS
,BON.TAUX_MAJO BON_TAUX_MAJO
,BON.MONTANT_MAJO BON_MONTANT_MAJO
,BON.CO_TVATIER_ID BON_CO_TVATIER_ID
,BON.CO_TVACODE_ID BON_CO_TVACODE_ID
,BON.TAUX_TVA BON_TAUX_TVA
,BON.MONTANT_TVA BON_MONTANT_TVA
,BON.MONTANT_LIGNE BON_MONTANT_LIGNE
,BON.CO_COMPTE_FACTURATION_ID BON_CO_COMPTE_FACTURATION_ID
,BON.DO_DOCVTED_ID BON_DO_DOCVTED_ID
,BON.DB_UNIT_ID BON_DB_UNIT_ID
,BON.ETALON BON_ETALON
,BON.DO_REGLIG_CI BON_DO_REGLIG_CI
,BON.DESIGNATION_ARTICLE BON_DESIGNATION_ARTICLE
,BON.DESIGNATION_DOSSIER BON_DESIGNATION_DOSSIER
,BON.DB_BADGE_ID BON_DB_BADGE_ID
,BON.DB_BADGE_TABLE_CI BON_DB_BADGE_TABLE_CI
,BON.DB_CHAPITR_ID BON_DB_CHAPITR_ID
,BON.ETAT_BON BON_ETAT_BON
,BON.DO_LOTBON_ID BON_DO_LOTBON_ID
,BON.ETAT_DOSSIER BON_ETAT_DOSSIER
,DOS.ID DOS_ID
,DOS.DO_LOT_ENT_ID DOS_DO_LOT_ENT_ID
,DOS.SE_CAS_ID DOS_SE_CAS_ID
,DOS.INT_TIDENT_CI DOS_INT_TIDENT_CI
,DOS.INT_IDROLE_ID DOS_INT_IDROLE_ID
,DOS.AD_ADR_ID DOS_AD_ADR_ID
,DOS.TYPE_VALEUR_DOSS DOS_TYPE_VALEUR_DOSS
,DOS.CODE_RECAP DOS_CODE_RECAP
,DOS.TAUX_REMISE DOS_TAUX_REMISE
,DOS.AS_PROD_REMI_ID DOS_AS_PROD_REMI_ID
,DOS.TAUX_MAJO DOS_TAUX_MAJO
,DOS.AS_PROD_MAJO_ID DOS_AS_PROD_MAJO_ID
,DOS.AS_LIBPRIX_ID DOS_AS_LIBPRIX_ID
,DOS.CO_COND_PMT_ID DOS_CO_COND_PMT_ID
,DOS.ETAT_DOSSIER DOS_ETAT_DOSSIER
,ENT.ID ENT_ID
,ENT.STATUS ENT_STATUS
,ENT.DO_DOCPROP_ID ENT_DO_DOCPROP_ID
,ENT.DO_DCMPPER_VARIANTE ENT_DO_DCMPPER_VARIANTE
,ENT.ABREGE ENT_ABREGE
,ENT.NOM ENT_NOM
,ENT.DATE_LOT ENT_DATE_LOT
,ENT.CODE_SOLDE ENT_CODE_SOLDE
,IDROLE.NOM_AFFICHE IDROLE_NOM_AFFICHE
,IDROLE.INT_IDENT_ID IDROLE_INT_IDENT_ID
,IDROLE.AD_ADR_ID IDROLE_AD_ADR_ID
,PROD.AS_FAMILLE_ID PROD_AS_FAM_ID
,PROD2.REFERENCE_INT_2 PROD2_REFERENCE_INT_2
FROM DO_LOT_DOSSIER DOS
,SE_CAS CAS
,DO_LOT_ENTETE ENT
,DO_LOT_BON BON
,INT_IDENT_ROLE IDROLE
,AS_PRODUIT PROD
,AS_PRODUIT PROD2
WHERE DOS.SE_CAS_ID = CAS.ID
and BON.DO_LOT_ENT_ID = ENT.ID
and BON.DO_LOT_ENT_ID = DOS.DO_LOT_ENT_ID
and BON.SE_CAS_ID = DOS.SE_CAS_ID
and BON.INT_TIDENT_CI = DOS.INT_TIDENT_CI
and BON.INT_IDROLE_ID = DOS.INT_IDROLE_ID
and IDROLE.ID = DOS.INT_IDROLE_ID
and PROD.ID(+) = BON.AS_PROD_ID
and PROD2.ID(+) = BON.AS_PROD_VEHI_ID
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.11 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 2.87 4.84 22568 7296 0 16
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 2.87 4.96 22568 7296 0 16
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 23 (IDINFO)
Rows Row Source Operation
------- ---------------------------------------------------
16 HASH JOIN
2636 TABLE ACCESS FULL DO_LOT_ENTETE
16 HASH JOIN OUTER
221227 HASH JOIN OUTER
221227 HASH JOIN
37568 HASH JOIN
18349 TABLE ACCESS FULL SE_CAS
37568 HASH JOIN
7246 TABLE ACCESS FULL INT_IDENT_ROLE
37568 TABLE ACCESS FULL DO_LOT_DOSSIER
221244 TABLE ACCESS FULL DO_LOT_BON
3822 TABLE ACCESS FULL AS_PRODUIT
3822 TABLE ACCESS FULL AS_PRODUIT
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: CHOOSE
16 HASH JOIN
2636 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'DO_LOT_ENTETE'
16 HASH JOIN (OUTER)
221227 HASH JOIN (OUTER)
221227 HASH JOIN
37568 HASH JOIN
18349 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'SE_CAS'
37568 HASH JOIN
7246 TABLE ACCESS GOAL: ANALYZED (FULL) OF
'INT_IDENT_ROLE'
37568 TABLE ACCESS GOAL: ANALYZED (FULL) OF
'DO_LOT_DOSSIER'
221244 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'DO_LOT_BON'
3822 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'AS_PRODUIT'
3822 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'AS_PRODUIT'
******************************************************************************** |
Partager