DBA Data[Home] [Help]

APPS.GMD_SS_LOT_WF_PKG dependencies on MTL_PARAMETERS

Line 82: with mtl_parameters.

78: BUG#4705797 Added ss_id to cursor.
79: BUG#4705867 Added sample_qty and uom
80: to cursor.
81: BUG#4912224 Replaced mtl_organizations
82: with mtl_parameters.
83: =====================================*/
84: --RLNAGARA B4705797 Added inventory_item_id to the select list of the CURSOR C1
85: CURSOR C1 IS
86: SELECT DISTINCT a.lot_number ,b.meaning, e.ss_no, f.description,e.inventory_item_id,

Line 95: mtl_parameters h

91: gmd_Qc_status b,
92: gmd_stability_studies_b e ,
93: gmd_stability_studies_tl f ,
94: mtl_system_items_kfv g,
95: mtl_parameters h
96: WHERE a.source_id = l_event_key
97: AND a.ss_id = e.ss_id
98: AND e.ss_id = f.ss_id
99: AND b.entity_type = 'STABILITY'