APPS.GMPRELAP dependencies on GMP_APS_OUTPUT_TBL

Line 132: FROM gmp_aps_output_tbl gmp,

128: gmp.processed_ind,
129: gmp.header_id,
130: gmp.scheduling_method,
131: gmp.rowid
132: FROM gmp_aps_output_tbl gmp,
133: mtl_system_items mtl
134: WHERE gmp.processed_ind > 0
135: AND gmp.inventory_item_id = mtl.inventory_item_id
136: AND gmp.organization_id = mtl.organization_id

Line 162: FROM gmp_aps_output_tbl gmp

158: gmp.processed_ind,
159: gmp.header_id,
160: gmp.scheduling_method,
161: gmp.rowid
162: FROM gmp_aps_output_tbl gmp
163: WHERE gmp.processed_ind > 0
164: AND gmp.organization_id = nvl(c_organization_id,gmp.organization_id)
165: AND gmp.plan_start_date >= nvl(c_fdate,gmp.plan_start_date)
166: AND gmp.plan_start_date <= nvl(c_tdate,gmp.plan_start_date)

Line 723: UPDATE gmp_aps_output_tbl

719: FND_MESSAGE.SET_NAME('GME','GME_INV_SHORTAGES');
720: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET||'-'||v_batch_no);
721: END IF;
722:
723: UPDATE gmp_aps_output_tbl
724: SET processed_ind = 0 ,
725: batch_id = v_batch_id
726: WHERE rowid = p_rowid
727: AND processed_ind > 0

Line 1214: UPDATE gmp_aps_output_tbl

1210: RAISE ERROR_MESSAGE;
1211: ELSE
1212: FND_MESSAGE.SET_NAME('GME','GME_RESCHEDULE');
1213: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET||' Return Success');
1214: UPDATE gmp_aps_output_tbl
1215: SET processed_ind = 0
1216: WHERE rowid = p_rowid
1217: AND header_id = p_header_id
1218: AND processed_ind > 0

Line 1397: UPDATE gmp_aps_output_tbl

1393: ELSE
1394: FND_MESSAGE.SET_NAME('GME','GME_API_BATCH_CANCELLED');
1395: FND_FILE.PUT_LINE(FND_FILE.LOG,'- '||FND_MESSAGE.GET||l_batch_no);
1396:
1397: UPDATE gmp_aps_output_tbl
1398: SET processed_ind = 0
1399: WHERE rowid = p_rowid
1400: AND processed_ind > 0 ;
1401: