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

Line 73: l_sample_id gmd_samples.sample_id%TYPE;

69: l_item mtl_system_items_vl.concatenated_segments%TYPE;
70: l_item_id NUMBER;
71: l_locator_id NUMBER;
72:
73: l_sample_id gmd_samples.sample_id%TYPE;
74: l_orgn_code mtl_parameters.organization_code%TYPE;
75: l_sample_no gmd_samples.sample_no%TYPE;
76: l_sample_desc gmd_samples.sample_desc%TYPE;
77: l_sample_qty gmd_samples.sample_qty%TYPE;

Line 75: l_sample_no gmd_samples.sample_no%TYPE;

71: l_locator_id NUMBER;
72:
73: l_sample_id gmd_samples.sample_id%TYPE;
74: l_orgn_code mtl_parameters.organization_code%TYPE;
75: l_sample_no gmd_samples.sample_no%TYPE;
76: l_sample_desc gmd_samples.sample_desc%TYPE;
77: l_sample_qty gmd_samples.sample_qty%TYPE;
78: l_sample_uom gmd_samples.sample_qty_uom%TYPE;
79: l_retain_as gmd_samples.retain_as%TYPE;

Line 76: l_sample_desc gmd_samples.sample_desc%TYPE;

72:
73: l_sample_id gmd_samples.sample_id%TYPE;
74: l_orgn_code mtl_parameters.organization_code%TYPE;
75: l_sample_no gmd_samples.sample_no%TYPE;
76: l_sample_desc gmd_samples.sample_desc%TYPE;
77: l_sample_qty gmd_samples.sample_qty%TYPE;
78: l_sample_uom gmd_samples.sample_qty_uom%TYPE;
79: l_retain_as gmd_samples.retain_as%TYPE;
80: l_priority gmd_samples.priority%TYPE;

Line 77: l_sample_qty gmd_samples.sample_qty%TYPE;

73: l_sample_id gmd_samples.sample_id%TYPE;
74: l_orgn_code mtl_parameters.organization_code%TYPE;
75: l_sample_no gmd_samples.sample_no%TYPE;
76: l_sample_desc gmd_samples.sample_desc%TYPE;
77: l_sample_qty gmd_samples.sample_qty%TYPE;
78: l_sample_uom gmd_samples.sample_qty_uom%TYPE;
79: l_retain_as gmd_samples.retain_as%TYPE;
80: l_priority gmd_samples.priority%TYPE;
81: l_source varchar2(100);

Line 78: l_sample_uom gmd_samples.sample_qty_uom%TYPE;

74: l_orgn_code mtl_parameters.organization_code%TYPE;
75: l_sample_no gmd_samples.sample_no%TYPE;
76: l_sample_desc gmd_samples.sample_desc%TYPE;
77: l_sample_qty gmd_samples.sample_qty%TYPE;
78: l_sample_uom gmd_samples.sample_qty_uom%TYPE;
79: l_retain_as gmd_samples.retain_as%TYPE;
80: l_priority gmd_samples.priority%TYPE;
81: l_source varchar2(100);
82: l_subinventory gmd_samples.subinventory%TYPE;

Line 79: l_retain_as gmd_samples.retain_as%TYPE;

75: l_sample_no gmd_samples.sample_no%TYPE;
76: l_sample_desc gmd_samples.sample_desc%TYPE;
77: l_sample_qty gmd_samples.sample_qty%TYPE;
78: l_sample_uom gmd_samples.sample_qty_uom%TYPE;
79: l_retain_as gmd_samples.retain_as%TYPE;
80: l_priority gmd_samples.priority%TYPE;
81: l_source varchar2(100);
82: l_subinventory gmd_samples.subinventory%TYPE;
83: l_lot_expiry varchar2(100);

Line 80: l_priority gmd_samples.priority%TYPE;

76: l_sample_desc gmd_samples.sample_desc%TYPE;
77: l_sample_qty gmd_samples.sample_qty%TYPE;
78: l_sample_uom gmd_samples.sample_qty_uom%TYPE;
79: l_retain_as gmd_samples.retain_as%TYPE;
80: l_priority gmd_samples.priority%TYPE;
81: l_source varchar2(100);
82: l_subinventory gmd_samples.subinventory%TYPE;
83: l_lot_expiry varchar2(100);
84: l_lot_manufacturing_dat varchar2(100);

Line 82: l_subinventory gmd_samples.subinventory%TYPE;

78: l_sample_uom gmd_samples.sample_qty_uom%TYPE;
79: l_retain_as gmd_samples.retain_as%TYPE;
80: l_priority gmd_samples.priority%TYPE;
81: l_source varchar2(100);
82: l_subinventory gmd_samples.subinventory%TYPE;
83: l_lot_expiry varchar2(100);
84: l_lot_manufacturing_dat varchar2(100);
85: l_sample_expirt varchar2(100);
86: l_lot_number gmd_samples.lot_number%TYPE;

Line 86: l_lot_number gmd_samples.lot_number%TYPE;

82: l_subinventory gmd_samples.subinventory%TYPE;
83: l_lot_expiry varchar2(100);
84: l_lot_manufacturing_dat varchar2(100);
85: l_sample_expirt varchar2(100);
86: l_lot_number gmd_samples.lot_number%TYPE;
87: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
88: l_qc_lab_orgn_code gmd_samples.qc_lab_orgn_code%TYPE;
89: l_sample_instant gmd_samples.instance_id%TYPE;
90:

Line 87: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;

83: l_lot_expiry varchar2(100);
84: l_lot_manufacturing_dat varchar2(100);
85: l_sample_expirt varchar2(100);
86: l_lot_number gmd_samples.lot_number%TYPE;
87: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
88: l_qc_lab_orgn_code gmd_samples.qc_lab_orgn_code%TYPE;
89: l_sample_instant gmd_samples.instance_id%TYPE;
90:
91: l_batch_no gme_batch_header.batch_no%TYPE;

Line 88: l_qc_lab_orgn_code gmd_samples.qc_lab_orgn_code%TYPE;

84: l_lot_manufacturing_dat varchar2(100);
85: l_sample_expirt varchar2(100);
86: l_lot_number gmd_samples.lot_number%TYPE;
87: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
88: l_qc_lab_orgn_code gmd_samples.qc_lab_orgn_code%TYPE;
89: l_sample_instant gmd_samples.instance_id%TYPE;
90:
91: l_batch_no gme_batch_header.batch_no%TYPE;
92: l_formula_no fm_form_mst_b.formula_no%TYPE;

Line 89: l_sample_instant gmd_samples.instance_id%TYPE;

85: l_sample_expirt varchar2(100);
86: l_lot_number gmd_samples.lot_number%TYPE;
87: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
88: l_qc_lab_orgn_code gmd_samples.qc_lab_orgn_code%TYPE;
89: l_sample_instant gmd_samples.instance_id%TYPE;
90:
91: l_batch_no gme_batch_header.batch_no%TYPE;
92: l_formula_no fm_form_mst_b.formula_no%TYPE;
93: l_oprn_no gmd_operations.oprn_no%TYPE;

Line 100: l_sample_instance gmd_samples.sample_instance%type;

96:
97: l_item_description mtl_system_items_vl.description%type;
98: l_sample_disposition varchar2(100);
99: l_date_drawn varchar2(100);
100: l_sample_instance gmd_samples.sample_instance%type;
101: l_print_count NUMBER;
102: l_reprint VARCHAR2(10);
103:
104: ---------------------------------------------------------------------------------------------

Line 159: from gmd_samples gsmp, mtl_lot_numbers mln,

155: (select lkups.meaning from gem_lookups lkups, gmd_sample_spec_disp disp where disp.sample_id=gsmp.sample_id and lookup_type='GMD_QC_SAMPLE_DISP' and lookup_code=disp.disposition) sample_disposition,
156: FND_DATE.DATE_TO_DISPLAYDT(gsmp.date_drawn, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) date_drawn,
157: gsmp.sample_instance
158:
159: from gmd_samples gsmp, mtl_lot_numbers mln,
160: fm_form_mst_b formulamst , gme_batch_header batchheader ,
161: gmd_operations operations , gmd_recipes_b recipes ,
162: gmd_routings_b routings , mtl_parameters para,
163: mtl_system_items_vl msi, mtl_parameters para2