DBA Data[Home] [Help]

APPS.GME_GANTT_LOV_PKG dependencies on GME_MATERIAL_DETAILS

Line 29: ,gme_material_details d

25: SELECT DISTINCT b.batch_id, batch_no, b.organization_id
26: ,batch_status, itd.concatenated_segments
27: ,itd.description
28: FROM gme_batch_header b
29: ,gme_material_details d
30: ,mtl_system_items_vl itd
31: WHERE b.organization_id = p_organization_id
32: AND UPPER (batch_no) LIKE p_input_field
33: AND b.batch_id = d.batch_id

Line 65: ,gme_material_details d

61: SELECT DISTINCT b.batch_id, batch_no, b.organization_id
62: ,batch_status, itd.concatenated_segments
63: ,itd.description
64: FROM gme_batch_header b
65: ,gme_material_details d
66: ,mtl_system_items_vl itd
67: WHERE b.organization_id = p_organization_id
68: AND UPPER (batch_no) LIKE p_input_field
69: AND b.batch_id = d.batch_id

Line 177: GME_MATERIAL_DETAILS d,

173: i.item_no,
174: i.item_desc1
175: FROM
176: GME_BATCH_HEADER b,
177: GME_MATERIAL_DETAILS d,
178: ic_item_mst i
179: WHERE
180: organization_id = p_organization_id AND
181: b.batch_id = d.batch_id AND