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_REPORT_GEN dependencies on GMD_SAMPLES

Line 1971: from gmd_samples

1967: , subinventory
1968: , sample_qty
1969: , sample_qty_uom
1970: , locator_id
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, NULL, '%%$#', lot_number) = decode(p_quality_samples_rec.lot, NULL, '%%$#',p_quality_samples_rec.lot)
1975: ;

Line 1979: from gmd_samples

1975: ;
1976:
1977: Cursor get_samples_count is
1978: select count(*)
1979: from gmd_samples
1980: where inventory_item_id = p_quality_samples_rec.inventory_item_id
1981: and organization_id = p_quality_samples_rec.current_org_id
1982: and decode(lot_number, NULL, '%%$#', lot_number) = decode(p_quality_samples_rec.lot, NULL, '%%$#',p_quality_samples_rec.lot)
1983: ;

Line 2001: from gmd_samples

1997: , subinventory
1998: , sample_qty
1999: , sample_qty_uom
2000: , locator_id
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, NULL, '%%$#', lot_number) = decode(p_quality_samples_rec.parent_lot, NULL, '%%$#',p_quality_samples_rec.parent_lot)
2005: ;

Line 2009: from gmd_samples

2005: ;
2006:
2007: Cursor get_samples_parent_count is
2008: select count(*)
2009: from gmd_samples
2010: where inventory_item_id = p_quality_samples_rec.inventory_item_id
2011: and organization_id = p_quality_samples_rec.current_org_id
2012: and decode(lot_number, NULL, '%%$#', lot_number) = decode(p_quality_samples_rec.parent_lot, NULL, '%%$#',p_quality_samples_rec.parent_lot)
2013: ;

Line 2025: from gmd_samples

2021: , subinventory
2022: , sample_qty
2023: , sample_qty_uom
2024: , locator_id
2025: from gmd_samples
2026: where sampling_event_id = p_quality_samples_rec.sampling_event_id
2027: ;
2028:
2029: /*Bug9644224 added below cursors to get the disposition and source */

Line 2066: l_from := ' from gmd_samples';

2062: ||' , sample_qty'
2063: ||' , sample_qty_uom'
2064: ||' , locator_id'
2065: ;
2066: l_from := ' from gmd_samples';
2067: l_where := ' where inventory_item_id = '||p_quality_samples_rec.inventory_item_id
2068: ||' and organization_id = '||p_quality_samples_rec.current_org_id
2069: ||' and decode(lot_number,NULL,'||''''||'%%$#'||''''||', lot_number) = '
2070: ||'decode(' ||''''|| p_quality_samples_rec.lot ||''''|| ',NULL, '||''''||'%%$#'||''''||', ' ||''''|| p_quality_samples_rec.lot ||''''|| ')'