DBA Data[Home] [Help]

APPS.GME_GANTT_LOV_PKG dependencies on GME_BATCH_HEADER

Line 28: FROM gme_batch_header b

24: IS
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

Line 64: FROM gme_batch_header b

60: IS
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

Line 176: GME_BATCH_HEADER b,

172: i.item_id,
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