eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_MOBILE_TXN dependencies on GME_MATERIAL_DETAILS

Line 1651: gme_material_details m

1647: CURSOR cur_get_step_status IS
1648: SELECT s.batchstep_no
1649: FROM gme_batch_steps s,
1650: gme_batch_step_items i,
1651: gme_material_details m
1652: WHERE m.batch_id = p_batch_id
1653: AND s.batch_id = p_batch_id
1654: AND i.batch_id = p_batch_id
1655: AND m.release_type = 2

Line 1746: FROM gme_material_details

1742: -- Bug#5331639. Compare wip_plan_qty instead of plan_qty
1743: NVL(wip_plan_qty, 0) wip_planned_qty,
1744: NVL(phantom_type, 0) phantom_ind,
1745: phantom_line_id
1746: FROM gme_material_details
1747: WHERE material_detail_id = p_material_detail_id
1748: AND organization_id = p_organization_id
1749: AND batch_id = p_batch_id;
1750:

Line 1837: l_material_details GME_MATERIAL_DETAILS%ROWTYPE;

1833: l_msg_list VARCHAR2(2000);
1834: l_msg_data VARCHAR2(2000);
1835: l_msg_index NUMBER;
1836: l_batch_header GME_BATCH_HEADER%ROWTYPE;
1837: l_material_details GME_MATERIAL_DETAILS%ROWTYPE;
1838: l_exception_material_tab GME_COMMON_PVT.exceptions_tab;
1839:
1840: BACKFLUSH_ERROR EXCEPTION;
1841:

Line 2071: gme_material_details m, -- nsinghi bug#5236906. Add join to gme_material_details and MLN

2067: TO_CHAR(l.last_update_date, 'MM/DD/YYYY HH24:MI:SS')
2068: FROM
2069: gme_pending_product_lots l,
2070: mtl_transaction_reasons r,
2071: gme_material_details m, -- nsinghi bug#5236906. Add join to gme_material_details and MLN
2072: mtl_lot_numbers n
2073: WHERE
2074: l.batch_id = p_batch_id AND
2075: l.material_detail_id = p_material_detail_id AND

Line 2134: gme_material_details m,

2130: TO_CHAR(l.last_update_date, 'MM/DD/YYYY HH24:MI:SS')
2131: FROM
2132: gme_pending_product_lots l,
2133: mtl_transaction_reasons r,
2134: gme_material_details m,
2135: mtl_lot_numbers n
2136: WHERE
2137: l.batch_id = p_batch_id AND
2138: l.material_detail_id = p_material_detail_id AND

Line 2189: l_material_detail_rec gme_material_details%ROWTYPE;

2185: x_error_msg OUT NOCOPY VARCHAR2)
2186: IS
2187: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2188: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2189: l_material_detail_rec gme_material_details%ROWTYPE;
2190: l_in_material_detail_rec gme_material_details%ROWTYPE;
2191: l_batch_header_rec gme_batch_header%ROWTYPE;
2192: l_message_count NUMBER;
2193: l_message_list VARCHAR2(2000);

Line 2190: l_in_material_detail_rec gme_material_details%ROWTYPE;

2186: IS
2187: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2188: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2189: l_material_detail_rec gme_material_details%ROWTYPE;
2190: l_in_material_detail_rec gme_material_details%ROWTYPE;
2191: l_batch_header_rec gme_batch_header%ROWTYPE;
2192: l_message_count NUMBER;
2193: l_message_list VARCHAR2(2000);
2194: l_create_lot VARCHAR2(6);

Line 2200: FROM mtl_system_items_b msi, gme_material_details gmd

2196:
2197: -- nsinghi bug#5236702. Set secondary qty only if item is DUOM controlled.
2198: CURSOR get_item_duom_ctl IS
2199: SELECT NVL(tracking_quantity_ind, 'P')
2200: FROM mtl_system_items_b msi, gme_material_details gmd
2201: WHERE gmd.inventory_item_id = msi.inventory_item_id AND
2202: gmd.organization_id = msi.organization_id AND
2203: gmd.material_detail_id = p_material_detail_id;
2204:

Line 2318: l_material_detail_rec gme_material_details%ROWTYPE;

2314: x_error_msg OUT NOCOPY VARCHAR2)
2315: IS
2316: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2317: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2318: l_material_detail_rec gme_material_details%ROWTYPE;
2319: l_in_material_detail_rec gme_material_details%ROWTYPE;
2320: l_batch_header_rec gme_batch_header%ROWTYPE;
2321: l_message_count NUMBER;
2322: l_message_list VARCHAR2(2000);

Line 2319: l_in_material_detail_rec gme_material_details%ROWTYPE;

2315: IS
2316: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2317: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2318: l_material_detail_rec gme_material_details%ROWTYPE;
2319: l_in_material_detail_rec gme_material_details%ROWTYPE;
2320: l_batch_header_rec gme_batch_header%ROWTYPE;
2321: l_message_count NUMBER;
2322: l_message_list VARCHAR2(2000);
2323: l_duom_ctl VARCHAR2(30);

Line 2328: FROM mtl_system_items_b msi, gme_material_details gmd

2324:
2325: -- nsinghi bug#5236702. Set secondary qty only if item is DUOM controlled.
2326: CURSOR get_item_duom_ctl IS
2327: SELECT NVL(tracking_quantity_ind, 'P')
2328: FROM mtl_system_items_b msi, gme_material_details gmd
2329: WHERE gmd.inventory_item_id = msi.inventory_item_id AND
2330: gmd.organization_id = msi.organization_id AND
2331: gmd.material_detail_id = p_material_detail_id;
2332:

Line 3144: FROM gme_material_details

3140: CURSOR Get_Mtl_Dtl IS
3141: SELECT release_type,
3142: NVL(phantom_type,0),
3143: phantom_line_id
3144: FROM gme_material_details
3145: WHERE material_detail_id = p_material_detail_id;
3146:
3147: CURSOR Get_pplot_count IS
3148: SELECT count(*)

Line 3253: FROM gme_material_details

3249: x_return_status OUT NOCOPY VARCHAR2,
3250: x_error_msg OUT NOCOPY VARCHAR2) IS
3251: CURSOR Get_Mtl_Dtl IS
3252: SELECT NVL(dispense_ind,'N')
3253: FROM gme_material_details
3254: WHERE material_detail_id = p_material_detail_id;
3255:
3256: ITEM_NOT_VALID EXCEPTION;
3257: l_dispense_ind VARCHAR2(2);

Line 3321: FROM gme_material_details

3317: x_error_msg OUT NOCOPY VARCHAR2) IS
3318:
3319: CURSOR Get_Release_Type IS
3320: SELECT release_type
3321: FROM gme_material_details
3322: WHERE material_detail_id = p_material_detail_id;
3323:
3324: CURSOR get_Batch_Status IS
3325: SELECT batch_status

Line 4436: FROM gme_material_details m, wms_item_locations_kfv loc

4432: IS
4433: CURSOR c_subinv_loc IS
4434: SELECT subinventory, loc.concatenated_segments,
4435: m.locator_id
4436: FROM gme_material_details m, wms_item_locations_kfv loc
4437: WHERE m.subinventory = loc.subinventory_code (+)
4438: AND m.locator_id = loc.inventory_location_id (+)
4439: AND m.batch_id = p_batch_id
4440: AND m.material_Detail_id = p_material_detail_id;

Line 4565: gme_material_details bl,

4561: mmt.created_by,
4562: mmt.transaction_type_id
4563: FROM gme_batch_header_vw bh,
4564: mtl_parameters mp,
4565: gme_material_details bl,
4566: mtl_system_items_vl msi,
4567: mtl_material_transactions mmt
4568: where mmt.transaction_set_id = p_txn_header_id AND
4569: bh.batch_id = mmt.TRANSACTION_SOURCE_ID AND