| SQL Id | SQL Text |
|---|
| 2nhcts7szbzar | SELECT
T1.CONFLICT_ID,
T1.LAST_UPD,
T1.CREATED,
T1.LAST_UPD_BY,
T1.CREATED_BY,
T1.MODIFICATION_NUM,
T1.ROW_ID,
T1.COMPLETED_FLG,
T1.TASK_ID_VAL
FROM
SIEBEL.S_TU_INST T1
WHERE
(T1.TASK_ID_VAL = :1) |
| arukbn6x207pq |
SELECT
T8.CONFLICT_ID,
T8.LAST_UPD,
T8.CREATED,
T8.LAST_UPD_BY,
T8.CREATED_BY,
T8.MODIFICATION_NUM,
T8.ROW_ID,
T6.X_PROMOTION_NAME,
T8.ATTRIB_03,
T1.CURR_PRI_LST_ID,
T8.ATTRIB_34,
T8.ATTRIB_07,
T5.NAME,
T8.ATTRIB_44,
T4.NAME,
T8.ATTRIB_39,
T8.ATTRIB_09,
T8.ATTRIB_06,
T8.ATTRIB_05,
T2.ORDER_NUM,
T8.ATTRIB_40,
T7.ORDER_SUB_TYPE,
T7.ORDER_TYPE,
T8.ATTRIB_37,
T8.ATTRIB_35,
T3.ADDR_NAME,
T8.ATTRIB_02,
T8.X_SUB_PROC_NAME,
T8.ATTRIB_04,
T8.ATTRIB_46,
T6.X_PROMOTION_NAME,
T5.OU_NUM,
T5.X_PRICE_TYPE_CD,
T5.X_ACCOUNT_TYPE,
T8.X_LATEST_CART_REVNUM,
T6.X_VIRTUAL_PROD_FLAG,
T8.X_VIRTUAL_PROD_NUM,
T8.X_ASSET_INFO,
T8.X_NEW_PROM_FLG
FROM
SIEBEL.S_ORG_EXT T1,
SIEBEL.S_ORDER T2,
SIEBEL.S_ADDR_PER T3,
SIEBEL.S_PROD_INT T4,
SIEBEL.S_ORG_EXT T5,
SIEBEL.S_PROD_INT T6,
SIEBEL.CX_PROC_ACTCD T7,
SIEBEL.S_CONTACT_XM T8
WHERE
T8.ATTRIB_03 = T1.PAR_ROW_ID (+) AND
T8.X_SUB_PROC_NAME = T7.BIZ_PROC_NAME (+) AND
T8.ATTRIB_44 = T5.PAR_ROW_ID (+) AND
T8.ATTRIB_39 = T4.ROW_ID (+) AND
T8.ATTRIB_05 = T2.ROW_ID (+) AND
T8.ATTRIB_02 = T3.ROW_ID (+) AND
T8.ATTRIB_46 = T6.ROW_ID (+) AND
(((T8.ROW_ID) = NVL (:1, 'NO_ROW_ID') AND T8
.X_STATUS_CD = '新建') AND
(T8.TYPE = 'SHCTBusinessLog')) |
| bsksjt0k9hh3g |
INSERT INTO SIEBEL.S_CONTACT_XM (
CONFLICT_ID,
DB_LAST_UPD_SRC,
DB_LAST_UPD,
LAST_UPD,
CREATED,
LAST_UPD_BY,
CREATED_BY,
MODIFICATION_NUM,
ROW_ID,
PAR_ROW_ID,
ATTRIB_08,
NAME,
TYPE,
X_LATEST_CART_REVNUM,
ATTRIB_14,
X_STATUS_CD,
X_GROUP_FLG,
X_NEW_PROM_FLG)
VALUES (:1, :2, current_date, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)
|
| fj2b3rrraadjx | SELECT
T5.CONFLICT_ID,
T5.LAST_UPD,
T5.CREATED,
T5.LAST_UPD_BY,
T5.CREATED_BY,
T5.MODIFICATION_NUM,
T5.ROW_ID,
T4.DUNS_NUM,
T1.CO_MSTR_ID,
T4.PR_CO_MSTR_ID,
T2.OWN_INST_ID,
T2.INTEGRATION_ID,
T3.CO_MSTR_ID,
T4.ROW_ID,
T4.PAR_ROW_ID,
T4.MODIFICATION_NUM,
T4.CREATED_BY,
T4.LAST_UPD_BY,
T4.CREATED,
T4.LAST_UPD,
T4.CONFLICT_ID,
T4.PAR_ROW_ID,
T2.ROW_ID,
T2.PAR_ROW_ID,
T2.MODIFICATION_NUM,
T2.CREATED_BY,
T2.LAST_UPD_BY,
T2.CREATED,
T2.LAST_UPD,
T2.CONFLICT_ID,
T2.PAR_ROW_ID,
T3.ROW_ID
FROM
SIEBEL.S_ACCNT_CO_MSTR T1,
SIEBEL.S_ORG_EXT_SS T2,
SIEBEL.S_ACCNT_CO_MSTR T3,
SIEBEL.S_ORG_EXT T4,
SIEBEL.S_PARTY T5
WHERE
T4.PR_CO_MSTR_ID = T1.ROW_ID (+) AND
T5.ROW_ID = T4.PAR_ROW_ID AND
T5.ROW_ID = T2.PAR_ROW_ID (+) AND
T1.CO_MSTR_ID = T3.ROW_ID (+) AND
((T5.ROW_ID = :1) AND
(T4.INT_ORG_FLG != 'Y')) |
| gptyps8uymuu7 |
INSERT INTO SIEBEL.S_AUDIT_ITEM (
CONFLICT_ID,
DB_LAST_UPD_SRC,
DB_LAST_UPD,
LAST_UPD,
CREATED,
LAST_UPD_BY,
CREATED_BY,
MODIFICATION_NUM,
ROW_ID,
AUDIT_LOG,
AUDIT_SOURCE_CD,
BC_BASE_TBL,
BUSCOMP_NAME,
OPERATION_DT,
SYNC_DT,
USER_ID,
FIELD_NAME,
GROUP_NUM,
ITEM_IDEN_NUM,
LINK_NAME,
NEW_VAL,
NODE_NAME,
OLD_VAL,
OPERATION_CD,
RECORD_ID,
TBL_NAME,
TBL_RECORD_ID,
CHILD_BC_BASE_TBL,
CHILD_RECORD_ID,
CHILD_BC_NAME)
VALUES (:1, :2, current_date, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, SIEBEL.S_AUDIT_ITEM_S.NEXTVAL, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28)
|