APPS.WSH_OPSM_ASN_ITEM_GENEALOGY dependencies on WSH_OPSM_ASN_ITEM_DETAILS_V

Line 77: wsh_opsm_asn_item_details_v waid ,

73: NULL parent_serial_number ,
74: 0 parent_inventory_item_id
75: FROM mtl_system_items_vl msi ,
76: mtl_lot_numbers mln ,
77: wsh_opsm_asn_item_details_v waid ,
78: wsh_delivery_details wdd
79: WHERE wdd.delivery_detail_id = p_delivery_detail_id
80: AND wdd.organization_id = p_organization_id
81: AND waid.delivery_detail_id = wdd.delivery_detail_id + 0

Line 326: wsh_opsm_asn_item_details_v waid ,

322: FROM mtl_object_genealogy mog ,
323: mtl_material_transactions mmt ,
324: wip_entities we ,
325: mtl_system_items_vl msi ,
326: wsh_opsm_asn_item_details_v waid ,
327: mtl_transaction_lot_numbers mtln ,
328: mtl_unit_transactions mut ,
329: mtl_lot_numbers mln ,
330: org_organization_definitions ood

Line 2415: wsh_opsm_asn_item_details_v waid ,

2411: NULL parent_serial_number ,
2412: 0 parent_inventory_item_id
2413: FROM mtl_system_items_vl msi ,
2414: mtl_lot_numbers mln ,
2415: wsh_opsm_asn_item_details_v waid ,
2416: wsh_delivery_details wdd
2417: WHERE wdd.delivery_detail_id = p_delivery_detail_id
2418: AND wdd.organization_id = p_organization_id
2419: AND waid.delivery_detail_id = wdd.delivery_detail_id + 0

Line 2660: wsh_opsm_asn_item_details_v waid ,

2656: FROM mtl_object_genealogy mog ,
2657: mtl_material_transactions mmt ,
2658: wip_entities we ,
2659: mtl_system_items_vl msi ,
2660: wsh_opsm_asn_item_details_v waid ,
2661: mtl_transaction_lot_numbers mtln ,
2662: mtl_unit_transactions mut ,
2663: mtl_lot_numbers mln ,
2664: org_organization_definitions ood