VIEW: APPS.FTP_CONDITION_ASSUMPTIONS_VL

Source

View Text - Preformatted

SELECT a.object_definition_id, a.line_item_id, a.currency, a.cond_sequence as condition_seq, a.cond_order as block_seq, DECODE(a.cond_sequence||a.cond_order, 00,'IF', a.cond_sequence||0,'ELSEIF', (SELECT decode(logical,1,'AND','OR') FROM ftp_tp_pp_conditions WHERE object_definition_id=a.object_definition_id AND line_item_id=a.line_item_id AND currency=a.currency AND cond_sequence=a.cond_sequence AND cond_order = a.cond_order-1)) as condition_term, a.column_data_type as attribute_type, a.compare_type as logic_type, a.table_name, a.column_name as left_operand, a.comparator, a.r_from as right_operand1, a.r_to as right_operand2, null as method FROM ftp_tp_pp_conditions a UNION ALL select b.object_definition_id, b.line_item_id, b.currency, b.cond_sequence as condition_seq, null as block_seq, DECODE((SELECT count(1) FROM ftp_tp_pp_conditions WHERE object_definition_id=b.object_definition_id and line_item_id=b.line_item_id AND currency=b.currency AND cond_sequence=b.cond_sequence), 0,'ELSE','THEN') as condition_term, null, null, null, null, null, null, null, b.tp_calc_method_code as method FROM ftp_transfer_price_rule b where b.tp_calc_method_code >= 0 and b.cond_sequence<> -1

View Text - HTML Formatted

SELECT A.OBJECT_DEFINITION_ID
, A.LINE_ITEM_ID
, A.CURRENCY
, A.COND_SEQUENCE AS CONDITION_SEQ
, A.COND_ORDER AS BLOCK_SEQ
, DECODE(A.COND_SEQUENCE||A.COND_ORDER
, 00
, 'IF'
, A.COND_SEQUENCE||0
, 'ELSEIF'
, (SELECT DECODE(LOGICAL
, 1
, 'AND'
, 'OR')
FROM FTP_TP_PP_CONDITIONS
WHERE OBJECT_DEFINITION_ID=A.OBJECT_DEFINITION_ID
AND LINE_ITEM_ID=A.LINE_ITEM_ID
AND CURRENCY=A.CURRENCY
AND COND_SEQUENCE=A.COND_SEQUENCE
AND COND_ORDER = A.COND_ORDER-1)) AS CONDITION_TERM
, A.COLUMN_DATA_TYPE AS ATTRIBUTE_TYPE
, A.COMPARE_TYPE AS LOGIC_TYPE
, A.TABLE_NAME
, A.COLUMN_NAME AS LEFT_OPERAND
, A.COMPARATOR
, A.R_FROM AS RIGHT_OPERAND1
, A.R_TO AS RIGHT_OPERAND2
, NULL AS METHOD
FROM FTP_TP_PP_CONDITIONS A UNION ALL SELECT B.OBJECT_DEFINITION_ID
, B.LINE_ITEM_ID
, B.CURRENCY
, B.COND_SEQUENCE AS CONDITION_SEQ
, NULL AS BLOCK_SEQ
, DECODE((SELECT COUNT(1)
FROM FTP_TP_PP_CONDITIONS
WHERE OBJECT_DEFINITION_ID=B.OBJECT_DEFINITION_ID
AND LINE_ITEM_ID=B.LINE_ITEM_ID
AND CURRENCY=B.CURRENCY
AND COND_SEQUENCE=B.COND_SEQUENCE)
, 0
, 'ELSE'
, 'THEN') AS CONDITION_TERM
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, B.TP_CALC_METHOD_CODE AS METHOD
FROM FTP_TRANSFER_PRICE_RULE B
WHERE B.TP_CALC_METHOD_CODE >= 0
AND B.COND_SEQUENCE<> -1