APPS.GME_REOPEN_BATCH_PVT dependencies on GME_MATERIAL_DETAILS

Line 59: FROM gme_material_details d

55: which are release type of "Automatic by Step" and attached to steps */
56: CURSOR cur_matl_phant_ids (v_batch_id NUMBER)
57: IS
58: SELECT d.phantom_id
59: FROM gme_material_details d
60: WHERE d.batch_id = v_batch_id
61: AND NVL (d.phantom_id, 0) > 0
62: AND NOT EXISTS (
63: SELECT 1

Line 76: l_material_details gme_material_details%ROWTYPE;

72: l_back_flush NUMBER;
73: l_error_count NUMBER;
74: l_row_count NUMBER;
75: l_ins_history gme_batch_history%ROWTYPE;
76: l_material_details gme_material_details%ROWTYPE;
77: l_material_details_tab gme_reopen_batch_pvt.material_details_tab;
78: l_phantom_ids gme_common_pvt.number_tab;
79: l_batch_header gme_batch_header%ROWTYPE;
80: l_in_batch_header gme_batch_header%ROWTYPE;

Line 450: ,gme_material_details md

446: -- See if any of the matl lines has been costed and frozen.
447: SELECT COUNT (1)
448: FROM cm_cmpt_dtl cst
449: ,cm_acst_led aled
450: ,gme_material_details md
451: ,gme_batch_header bh
452: WHERE bh.batch_id = l_batch_id
453: AND bh.batch_id = md.batch_id
454: AND md.material_detail_id = aled.transline_id

Line 464: FROM cm_cmpt_dtl cst, cm_acst_led aled, gme_material_details md, gme_batch_header bh, gmf_period_statuses d

460: -- Bug 10634518 - Frontport 11i bug 6853392 but also rework using R12 tables and joins per GMF team.
461: CURSOR c_get_period_info (l_batch_id IN gme_batch_header.batch_id%TYPE)
462: IS
463: SELECT COUNT(1)
464: FROM cm_cmpt_dtl cst, cm_acst_led aled, gme_material_details md, gme_batch_header bh, gmf_period_statuses d
465: WHERE bh.batch_id = l_batch_id
466: AND bh.batch_id = md.batch_id
467: AND md.material_detail_id = aled.transline_id
468: AND aled.source_ind = 0