DBA Data[Home] [Help]

APPS.GML_BATCH_OM_RES_PVT dependencies on GME_BATCH_HEADER

Line 130: From gme_batch_header

126: and line_type <> -1
127: ;
128: Cursor get_new_batch_cmpt_date (p_batch_id IN NUMBER) is
129: Select plan_cmplt_date
130: From gme_batch_header
131: where batch_id = p_batch_id;
132:
133: BEGIN
134: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1001: FROM gme_batch_header

997: and reserved_qty <> 0;
998:
999: CURSOR Get_batch_type(p_batch_id IN NUMBER) IS
1000: SELECT batch_type
1001: FROM gme_batch_header
1002: WHERE batch_id = p_batch_id;
1003:
1004:
1005: CURSOR So_line_id_for_batch_line(p_batch_line_id IN NUMBER) Is

Line 1015: gme_batch_header gh

1011:
1012: CURSOR get_batch_id_for_line(p_batch_line_id IN NUMBER) Is
1013: SELECT gl.batch_id,gh.batch_type
1014: FROM gme_material_details gl,
1015: gme_batch_header gh
1016: WHERE gl.material_detail_id = p_batch_line_id
1017: and gl.batch_id = gh.batch_id;
1018:
1019: