eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_EXTRACT_PERSON_CUST_BO_PVT dependencies on HZ_BUS_OBJ_TRACKING

Line 211: from hz_bus_obj_tracking

207:
208:
209: cursor check_person_action_type_csr is
210: select child_operation_flag
211: from hz_bus_obj_tracking
212: where event_id = p_event_id
213: and child_bo_code = 'PERSON'
214: and parent_bo_code = 'PERSON_CUST';
215:

Line 874: FROM HZ_BUS_OBJ_TRACKING

870: CHILD_BO_CODE,
871: CHILD_ENTITY_NAME,
872: CHILD_ID,
873: populated_flag
874: FROM HZ_BUS_OBJ_TRACKING
875: where event_id = p_event_id
876: START WITH child_id = p_root_id
877: AND child_entity_name = 'HZ_PARTIES'
878: AND PARENT_BO_CODE IS NULL

Line 888: FROM HZ_BUS_OBJ_TRACKING

884: and event_id = PRIOR event_id;
885:
886: cursor c2 is
887: select child_event_id,creation_date
888: FROM HZ_BUS_OBJ_TRACKING
889: where event_id = p_event_id
890: and parent_bo_code is null
891: and rownum = 1;
892:

Line 896: FROM HZ_BUS_OBJ_TRACKING

892:
893: CURSOR c_get_child_event_id(cp_creation_date DATE) IS
894:
895: SELECT event_id
896: FROM HZ_BUS_OBJ_TRACKING
897: WHERE creation_date = cp_creation_date
898: AND child_id = p_root_id
899: AND child_event_id IS NULL
900: and event_id <> p_event_id

Line 2026: FROM HZ_BUS_OBJ_TRACKING

2022: CHILD_BO_CODE,
2023: CHILD_ENTITY_NAME,
2024: CHILD_ID,
2025: populated_flag
2026: FROM HZ_BUS_OBJ_TRACKING
2027: where event_id = p_event_id
2028: START WITH child_id = p_root_id
2029: AND child_entity_name = 'HZ_PARTIES'
2030: AND PARENT_BO_CODE IS NULL

Line 2040: FROM HZ_BUS_OBJ_TRACKING

2036: and event_id = PRIOR event_id;
2037:
2038: cursor c2 is
2039: select child_event_id,creation_date
2040: FROM HZ_BUS_OBJ_TRACKING
2041: where event_id = p_event_id
2042: and parent_bo_code is null
2043: and rownum = 1;
2044:

Line 2048: FROM HZ_BUS_OBJ_TRACKING

2044:
2045: CURSOR c_get_child_event_id(cp_creation_date DATE) IS
2046:
2047: SELECT event_id
2048: FROM HZ_BUS_OBJ_TRACKING
2049: WHERE creation_date = cp_creation_date
2050: AND child_id = p_root_id
2051: AND child_event_id IS NULL
2052: and event_id <> p_event_id