APPS.INV_GENEALOGY_REPORT_GEN dependencies on GMD_SAMPLES

Line 1963: from gmd_samples

1959: , subinventory
1960: , sample_qty
1961: , sample_qty_uom
1962: , locator_id
1963: from gmd_samples
1964: where inventory_item_id = p_quality_samples_rec.inventory_item_id
1965: and organization_id = p_quality_samples_rec.current_org_id
1966: and decode(lot_number,'%%XX', lot_number) = decode(p_quality_samples_rec.lot, '%%XX', p_quality_samples_rec.lot)
1967: ;

Line 1971: from gmd_samples

1967: ;
1968:
1969: Cursor get_samples_count is
1970: select count(*)
1971: from gmd_samples
1972: where inventory_item_id = p_quality_samples_rec.inventory_item_id
1973: and organization_id = p_quality_samples_rec.current_org_id
1974: and decode(lot_number,'%%XX', lot_number) = decode(p_quality_samples_rec.lot, '%%XX', p_quality_samples_rec.lot)
1975: ;

Line 1993: from gmd_samples

1989: , subinventory
1990: , sample_qty
1991: , sample_qty_uom
1992: , locator_id
1993: from gmd_samples
1994: where inventory_item_id = p_quality_samples_rec.inventory_item_id
1995: and organization_id = p_quality_samples_rec.current_org_id
1996: and decode(lot_number,'%%XX', lot_number) = decode(p_quality_samples_rec.parent_lot, '%%XX', p_quality_samples_rec.parent_lot)
1997: ;

Line 2001: from gmd_samples

1997: ;
1998:
1999: Cursor get_samples_parent_count is
2000: select count(*)
2001: from gmd_samples
2002: where inventory_item_id = p_quality_samples_rec.inventory_item_id
2003: and organization_id = p_quality_samples_rec.current_org_id
2004: and decode(lot_number,'%%XX', lot_number) = decode(p_quality_samples_rec.parent_lot, '%%XX', p_quality_samples_rec.parent_lot)
2005: ;

Line 2017: from gmd_samples

2013: , subinventory
2014: , sample_qty
2015: , sample_qty_uom
2016: , locator_id
2017: from gmd_samples
2018: where sampling_event_id = p_quality_samples_rec.sampling_event_id
2019: ;
2020:
2021: Begin

Line 2034: l_from := ' from gmd_samples';

2030: ||' , sample_qty'
2031: ||' , sample_qty_uom'
2032: ||' , locator_id'
2033: ;
2034: l_from := ' from gmd_samples';
2035: l_where := ' where inventory_item_id = '||p_quality_samples_rec.inventory_item_id
2036: ||' and organization_id = '||p_quality_samples_rec.current_org_id
2037: ||' and decode(lot_number,'||''''||'%%XX'||''''||', lot_number) = '
2038: ||'decode('||p_quality_samples_rec.lot||', '||''''||'%%XX'||''''||', '||p_quality_samples_rec.lot||')'