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 668: FROM mtl_object_genealogy mog, mtl_serial_numbers msn

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

Line 872: FROM mtl_object_genealogy

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

Line 885: FROM mtl_object_genealogy

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

Line 898: FROM mtl_object_genealogy

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

Line 911: FROM mtl_object_genealogy

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

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

924: IF (l_dummy = 0) THEN
925: -- No need of this condition AND (l_object_id <> l_parent_object_id)
926: IF (l_debug = 1) THEN
927: mydebug('{{- Only if the relationship does not exist that a new record is }}' ||
928: '{{ inserted in mtl_object_genealogy for the given l_object_id, l_object_id2 }} ' ||
929: '{{ and l_parent_object_id, l_parent_object_id2 combination }}' );
930: mydebug('{{- If the relationship is between lot+serial controlled item, make sure }}' ||
931: '{{ that columns with 2 as suffix are also populated in the table }}'
932: );

Line 934: INSERT INTO mtl_object_genealogy

930: mydebug('{{- If the relationship is between lot+serial controlled item, make sure }}' ||
931: '{{ that columns with 2 as suffix are also populated in the table }}'
932: );
933: END IF ;
934: INSERT INTO mtl_object_genealogy
935: (
936: object_id
937: , object_type
938: , object_id2 -- R12 Genealogy Enhancements

Line 1276: FROM mtl_object_genealogy

1272: SELECT 'Y'
1273: INTO l_dummy_char
1274: FROM DUAL
1275: WHERE EXISTS( SELECT *
1276: FROM mtl_object_genealogy
1277: WHERE genealogy_type = 5
1278: AND object_id = l_object_id
1279: AND end_date_active IS NULL);
1280:

Line 1283: FROM mtl_object_genealogy

1279: AND end_date_active IS NULL);
1280:
1281: SELECT start_date_active
1282: INTO l_dummy_date
1283: FROM mtl_object_genealogy
1284: WHERE genealogy_type = 5
1285: AND object_id = l_object_id
1286: AND end_date_active IS NULL;
1287:

Line 1303: UPDATE mtl_object_genealogy

1299: RAISE lg_exc_error;
1300: END;
1301: END IF;
1302:
1303: UPDATE mtl_object_genealogy
1304: SET last_update_date = SYSDATE
1305: , last_updated_by = -1
1306: , end_date_active = p_end_date_active
1307: , update_txn_id = p_update_txn_id

Line 1630: Delete from mtl_object_genealogy

1626: x_return_status := lg_ret_sts_success;
1627:
1628: -- API body
1629:
1630: Delete from mtl_object_genealogy
1631: where object_id = p_object_id
1632: and start_date_active = p_start_date_active
1633: and end_date_active = p_end_date_active
1634: and genealogy_type = 5;

Line 2853: UPDATE mtl_object_genealogy

2849: IF p_transaction_type = 'ASSEMBLY_RETURN' THEN
2850: IF l_object_id2 IS NULL THEN
2851: IF (l_debug = 1) THEN mydebug('{{- AR: Genealogy is not between lot+serial controlled items }}'); END IF;
2852: BEGIN
2853: UPDATE mtl_object_genealogy
2854: SET last_update_date = SYSDATE
2855: , last_updated_by = -1
2856: , end_date_active = l_end_date_active
2857: , update_txn_id = p_update_txn_id

Line 2890: UPDATE mtl_object_genealogy

2886: IF (l_debug = 1) THEN
2887: mydebug(' {{- AR: Genealogy is between lot+serial child and non lot+serial parent }}');
2888: END IF;
2889: BEGIN
2890: UPDATE mtl_object_genealogy
2891: SET last_update_date = SYSDATE
2892: , last_updated_by = -1
2893: , end_date_active = l_end_date_active
2894: , update_txn_id = p_update_txn_id

Line 2924: UPDATE mtl_object_genealogy

2920: ELSE -- IF p_transaction_type = 'COMP_RETURN' OR NULL
2921: IF l_object_id2 IS NULL THEN
2922: IF (l_debug = 1) THEN mydebug('{{- CR: Genealogy is not between lot+serial controlled items }}'); END IF;
2923: BEGIN
2924: UPDATE mtl_object_genealogy
2925: SET last_update_date = SYSDATE
2926: , last_updated_by = -1
2927: , end_date_active = l_end_date_active
2928: , update_txn_id = p_update_txn_id

Line 2960: UPDATE mtl_object_genealogy

2956: IF (l_debug = 1) THEN
2957: mydebug(' {{- CR: Genealogy is between lot+serial child and non lot+serial parent }}');
2958: END IF;
2959: BEGIN
2960: UPDATE mtl_object_genealogy
2961: SET last_update_date = SYSDATE
2962: , last_updated_by = -1
2963: , end_date_active = l_end_date_active
2964: , update_txn_id = p_update_txn_id