APPS.GMPRELAP dependencies on GMP_APS_OUTPUT_TBL

Line 138: FROM gmp_aps_output_tbl gmp,

134: gmp.processed_ind,
135: gmp.header_id,
136: gmp.scheduling_method,
137: gmp.rowid
138: FROM gmp_aps_output_tbl gmp,
139: mtl_system_items mtl
140: WHERE gmp.processed_ind > 0
141: AND gmp.process_id = nvl(c_process_id,gmp.process_id) /* vpedarla bug: 7258717 */
142: AND gmp.inventory_item_id = mtl.inventory_item_id

Line 170: FROM gmp_aps_output_tbl gmp

166: gmp.processed_ind,
167: gmp.header_id,
168: gmp.scheduling_method,
169: gmp.rowid
170: FROM gmp_aps_output_tbl gmp
171: WHERE gmp.processed_ind > 0
172: AND gmp.process_id = nvl(c_process_id,gmp.process_id) /* vpedarla bug: 7258717 */
173: AND gmp.organization_id = nvl(c_organization_id,gmp.organization_id)
174: AND gmp.plan_start_date >= nvl(c_fdate,gmp.plan_start_date)

Line 843: UPDATE gmp_aps_output_tbl

839: FND_MESSAGE.SET_NAME('GME','GME_INV_SHORTAGES');
840: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET||'-'||v_batch_no);
841: END IF;
842:
843: UPDATE gmp_aps_output_tbl
844: SET processed_ind = 0 ,
845: batch_id = v_batch_id
846: WHERE rowid = p_rowid
847: AND processed_ind > 0

Line 1431: UPDATE gmp_aps_output_tbl

1427: WHERE BATCH_ID = l_gme_batch_header.batch_id;
1428: END IF;
1429: -- Vpedarla Bug: 8348883 end
1430:
1431: UPDATE gmp_aps_output_tbl
1432: SET processed_ind = 0
1433: WHERE rowid = p_rowid
1434: AND header_id = p_header_id
1435: AND processed_ind > 0

Line 1636: UPDATE gmp_aps_output_tbl

1632: ELSE
1633: FND_MESSAGE.SET_NAME('GME','GME_API_BATCH_CANCELLED');
1634: FND_FILE.PUT_LINE(FND_FILE.LOG,'- '||FND_MESSAGE.GET||l_batch_no);
1635:
1636: UPDATE gmp_aps_output_tbl
1637: SET processed_ind = 0
1638: WHERE rowid = p_rowid
1639: AND processed_ind > 0 ;
1640: