DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on JTF_OBJECT_PURGE_PARAM_TMP

Line 15353: UPDATE jtf_object_purge_param_tmp

15349: -- if the charge lines are ACTUAL and do not have
15350: -- a line id attached to them, then the corresponding
15351: -- SRs cannot be purged.
15352:
15353: UPDATE jtf_object_purge_param_tmp
15354: SET
15355: purge_status = 'E'
15356: , purge_error_message = 'CS:CS_CHG_LINE_VAL_ERR'
15357: WHERE

Line 15364: , jtf_object_purge_param_tmp t

15360: SELECT
15361: t.object_id
15362: FROM
15363: cs_estimate_details e
15364: , jtf_object_purge_param_tmp t
15365: WHERE
15366: e.incident_id = t.object_id
15367: AND e.charge_line_type = 'ACTUAL'
15368: AND e.order_line_id IS NULL

Line 15623: jtf_object_purge_param_tmp

15619: (
15620: SELECT /*+ no_unnest no_semijoin cardinality(10) */
15621: object_id
15622: FROM
15623: jtf_object_purge_param_tmp
15624: WHERE
15625: processing_set_id = p_processing_set_id
15626: AND object_type = 'SR'
15627: AND NVL(purge_status, 'S') = 'S'