DBA Data[Home] [Help]

APPS.GMD_SS_TIMEPOINT_WF_PKG dependencies on MTL_ITEM_LOCATIONS_KFV

Line 98: mtl_item_locations_kfv j,

94: gmd_stability_studies_b e ,
95: gmd_stability_studies_tl f ,
96: gmd_ss_variants h,
97: gmd_specifications i,
98: mtl_item_locations_kfv j,
99: mtl_parameters k
100: where c.time_point_id = l_event_key
101: and c.variant_id = h.variant_id
102: and h.material_source_id = a.source_id

Line 116: -- JD to C1 added organization match on mtl_item_locations_kfv and

112: and h.storage_organization_id = j.organization_id(+)
113: and k.organization_id = e.organization_id
114: and f.language = userenv('LANG');
115:
116: -- JD to C1 added organization match on mtl_item_locations_kfv and
117: -- outer join.
118: -- added language to gmd_stability_studies_tl
119: -- 10/20/2005
120: