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.INV_GENEALOGY_PUB dependencies on MTL_OBJECT_GENEALOGY

Line 159: FROM mtl_object_genealogy mog

155: SELECT 1
156: INTO l_dummy
157: FROM DUAL
158: WHERE parent_object_id IN (SELECT mog.object_id
159: FROM mtl_object_genealogy mog
160: WHERE (end_date_active IS NULL OR end_date_active >= start_date)
161: AND parent_object_id = l_object_id
162: AND genealogy_type = 5);
163: EXCEPTION

Line 173: FROM mtl_object_genealogy mog

169: SELECT 1
170: INTO l_dummy
171: FROM DUAL
172: WHERE parent_object_id IN (SELECT mog.object_id
173: FROM mtl_object_genealogy mog
174: WHERE (((start_date_active <= start_date)
175: AND (end_date_active IS NULL
176: OR (end_date_active >= start_date)))
177: OR ((start_date_active >= start_date)

Line 198: FROM mtl_object_genealogy

194: IF end_date IS NULL THEN
195: FOR object_id_rec IN (SELECT object_id
196: , start_date_active
197: , end_date_active
198: FROM mtl_object_genealogy
199: WHERE genealogy_type = 5
200: AND parent_object_id = l_object_id
201: AND (end_date_active IS NULL OR end_date_active >= start_date))
202: LOOP

Line 257: FROM mtl_object_genealogy

253: ELSE
254: FOR object_id_rec IN (SELECT object_id
255: , start_date_active
256: , end_date_active
257: FROM mtl_object_genealogy
258: WHERE genealogy_type = 5
259: AND parent_object_id = l_object_id
260: AND (((start_date_active <= start_date)
261: AND (end_date_active IS NULL

Line 670: FROM mtl_object_genealogy mog, mtl_serial_numbers msn

666: SELECT mog.start_date_active start_date_active
667: , mog.end_date_active end_date_active
668: , msn.serial_number parent_serial_number
669: , msn.inventory_item_id parent_inventory_item_id
670: FROM mtl_object_genealogy mog, mtl_serial_numbers msn
671: WHERE mog.object_id = l_object_id
672: AND msn.gen_object_id = mog.parent_object_id
673: AND mog.genealogy_type = 5;
674: BEGIN

Line 876: FROM mtl_object_genealogy

872: mydebug('{{- Genealogy is not between lot+serial controlled items }}');
873: END IF;
874: SELECT COUNT(*)
875: INTO l_dummy
876: FROM mtl_object_genealogy
877: WHERE object_id = l_object_id
878: AND object_id2 IS NULL -- added this for lot+serial controlled items
879: AND parent_object_id = l_parent_object_id
880: AND parent_object_id2 IS NULL

Line 889: FROM mtl_object_genealogy

885: mydebug('{{- Genealogy is between non lot+serial child and lot+serial parent}}');
886: END IF;
887: SELECT COUNT(*)
888: INTO l_dummy
889: FROM mtl_object_genealogy
890: WHERE object_id = l_object_id
891: AND object_id2 IS NULL -- added this for lot+serial controlled items
892: AND parent_object_id = l_parent_object_id
893: AND parent_object_id2 = l_parent_object_id2

Line 902: FROM mtl_object_genealogy

898: mydebug(' {{- Genealogy is between lot+serial child and non lot+serial parent }}');
899: END IF;
900: SELECT COUNT(*)
901: INTO l_dummy
902: FROM mtl_object_genealogy
903: WHERE object_id = l_object_id
904: AND object_id2 = l_object_id2 -- added this for lot+serial controlled items
905: AND parent_object_id = l_parent_object_id
906: AND parent_object_id2 IS NULL

Line 915: FROM mtl_object_genealogy

911: mydebug(' {{- Genealogy is between lot+serial child and lot+serial parent }}');
912: END IF;
913: SELECT COUNT(*)
914: INTO l_dummy
915: FROM mtl_object_genealogy
916: WHERE object_id = l_object_id
917: AND object_id2 = l_object_id2 -- added this for lot+serial controlled items
918: AND parent_object_id = l_parent_object_id
919: AND parent_object_id2 = l_parent_object_id2

Line 930: FROM mtl_object_genealogy

926: END IF ;
927:
928: --Bug 10190740: prevent simple loops in genealogy
929: SELECT Count(*) INTO retval
930: FROM mtl_object_genealogy
931: WHERE parent_object_id = l_object_id
932: AND object_id = l_parent_object_id
933: AND genealogy_type<>1; -- added for the Genealogy bug 16512538
934:

Line 943: '{{ inserted in mtl_object_genealogy for the given l_object_id, l_object_id2 }} ' ||

939: IF (l_dummy = 0) AND (retval = 0) THEN
940: -- No need of this condition AND (l_object_id <> l_parent_object_id)
941: IF (l_debug = 1) THEN
942: mydebug('{{- Only if the relationship does not exist that a new record is }}' ||
943: '{{ inserted in mtl_object_genealogy for the given l_object_id, l_object_id2 }} ' ||
944: '{{ and l_parent_object_id, l_parent_object_id2 combination }}' );
945: mydebug('{{- If the relationship is between lot+serial controlled item, make sure }}' ||
946: '{{ that columns with 2 as suffix are also populated in the table }}'
947: );

Line 950: INSERT INTO mtl_object_genealogy

946: '{{ that columns with 2 as suffix are also populated in the table }}'
947: );
948: END IF ;
949:
950: INSERT INTO mtl_object_genealogy
951: (
952: object_id
953: , object_type
954: , object_id2 -- R12 Genealogy Enhancements

Line 1296: FROM mtl_object_genealogy

1292: SELECT 'Y'
1293: INTO l_dummy_char
1294: FROM DUAL
1295: WHERE EXISTS( SELECT *
1296: FROM mtl_object_genealogy
1297: WHERE genealogy_type = 5
1298: AND object_id = l_object_id
1299: AND end_date_active IS NULL);
1300:

Line 1303: FROM mtl_object_genealogy

1299: AND end_date_active IS NULL);
1300:
1301: SELECT start_date_active
1302: INTO l_dummy_date
1303: FROM mtl_object_genealogy
1304: WHERE genealogy_type = 5
1305: AND object_id = l_object_id
1306: AND end_date_active IS NULL;
1307:

Line 1323: UPDATE mtl_object_genealogy

1319: RAISE lg_exc_error;
1320: END;
1321: END IF;
1322:
1323: UPDATE mtl_object_genealogy
1324: SET last_update_date = SYSDATE
1325: , last_updated_by = -1
1326: , end_date_active = p_end_date_active
1327: , update_txn_id = p_update_txn_id

Line 1653: Delete from mtl_object_genealogy

1649: x_return_status := lg_ret_sts_success;
1650:
1651: -- API body
1652:
1653: Delete from mtl_object_genealogy
1654: where object_id = p_object_id
1655: and start_date_active = p_start_date_active
1656: and end_date_active = p_end_date_active
1657: and genealogy_type = 5;

Line 2876: UPDATE mtl_object_genealogy

2872: IF p_transaction_type = 'ASSEMBLY_RETURN' THEN
2873: IF l_object_id2 IS NULL THEN
2874: IF (l_debug = 1) THEN mydebug('{{- AR: Genealogy is not between lot+serial controlled items }}'); END IF;
2875: BEGIN
2876: UPDATE mtl_object_genealogy
2877: SET last_update_date = SYSDATE
2878: , last_updated_by = -1
2879: , end_date_active = l_end_date_active
2880: , update_txn_id = p_update_txn_id

Line 2913: UPDATE mtl_object_genealogy

2909: IF (l_debug = 1) THEN
2910: mydebug(' {{- AR: Genealogy is between lot+serial child and non lot+serial parent }}');
2911: END IF;
2912: BEGIN
2913: UPDATE mtl_object_genealogy
2914: SET last_update_date = SYSDATE
2915: , last_updated_by = -1
2916: , end_date_active = l_end_date_active
2917: , update_txn_id = p_update_txn_id

Line 2947: UPDATE mtl_object_genealogy

2943: ELSE -- IF p_transaction_type = 'COMP_RETURN' OR NULL
2944: IF l_object_id2 IS NULL THEN
2945: IF (l_debug = 1) THEN mydebug('{{- CR: Genealogy is not between lot+serial controlled items }}'); END IF;
2946: BEGIN
2947: UPDATE mtl_object_genealogy
2948: SET last_update_date = SYSDATE
2949: , last_updated_by = -1
2950: , end_date_active = l_end_date_active
2951: , update_txn_id = p_update_txn_id

Line 2983: UPDATE mtl_object_genealogy

2979: IF (l_debug = 1) THEN
2980: mydebug(' {{- CR: Genealogy is between lot+serial child and non lot+serial parent }}');
2981: END IF;
2982: BEGIN
2983: UPDATE mtl_object_genealogy
2984: SET last_update_date = SYSDATE
2985: , last_updated_by = -1
2986: , end_date_active = l_end_date_active
2987: , update_txn_id = p_update_txn_id