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 1555: gme_material_details m

1551: CURSOR cur_get_step_status IS
1552: SELECT s.batchstep_no
1553: FROM gme_batch_steps s,
1554: gme_batch_step_items i,
1555: gme_material_details m
1556: WHERE m.batch_id = p_batch_id
1557: AND s.batch_id = p_batch_id
1558: AND i.batch_id = p_batch_id
1559: AND m.release_type = 2

Line 1650: FROM gme_material_details

1646: -- Bug#5331639. Compare wip_plan_qty instead of plan_qty
1647: NVL(wip_plan_qty, 0) wip_planned_qty,
1648: NVL(phantom_type, 0) phantom_ind,
1649: phantom_line_id
1650: FROM gme_material_details
1651: WHERE material_detail_id = p_material_detail_id
1652: AND organization_id = p_organization_id
1653: AND batch_id = p_batch_id;
1654:

Line 1741: l_material_details GME_MATERIAL_DETAILS%ROWTYPE;

1737: l_msg_list VARCHAR2(2000);
1738: l_msg_data VARCHAR2(2000);
1739: l_msg_index NUMBER;
1740: l_batch_header GME_BATCH_HEADER%ROWTYPE;
1741: l_material_details GME_MATERIAL_DETAILS%ROWTYPE;
1742: l_exception_material_tab GME_COMMON_PVT.exceptions_tab;
1743:
1744: BACKFLUSH_ERROR EXCEPTION;
1745:

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

1971: TO_CHAR(l.last_update_date, 'MM/DD/YYYY HH24:MI:SS')
1972: FROM
1973: gme_pending_product_lots l,
1974: mtl_transaction_reasons r,
1975: gme_material_details m, -- nsinghi bug#5236906. Add join to gme_material_details and MLN
1976: mtl_lot_numbers n
1977: WHERE
1978: l.batch_id = p_batch_id AND
1979: l.material_detail_id = p_material_detail_id AND

Line 2038: gme_material_details m,

2034: TO_CHAR(l.last_update_date, 'MM/DD/YYYY HH24:MI:SS')
2035: FROM
2036: gme_pending_product_lots l,
2037: mtl_transaction_reasons r,
2038: gme_material_details m,
2039: mtl_lot_numbers n
2040: WHERE
2041: l.batch_id = p_batch_id AND
2042: l.material_detail_id = p_material_detail_id AND

Line 2093: l_material_detail_rec gme_material_details%ROWTYPE;

2089: x_error_msg OUT NOCOPY VARCHAR2)
2090: IS
2091: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2092: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2093: l_material_detail_rec gme_material_details%ROWTYPE;
2094: l_in_material_detail_rec gme_material_details%ROWTYPE;
2095: l_batch_header_rec gme_batch_header%ROWTYPE;
2096: l_message_count NUMBER;
2097: l_message_list VARCHAR2(2000);

Line 2094: l_in_material_detail_rec gme_material_details%ROWTYPE;

2090: IS
2091: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2092: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2093: l_material_detail_rec gme_material_details%ROWTYPE;
2094: l_in_material_detail_rec gme_material_details%ROWTYPE;
2095: l_batch_header_rec gme_batch_header%ROWTYPE;
2096: l_message_count NUMBER;
2097: l_message_list VARCHAR2(2000);
2098: l_create_lot VARCHAR2(6);

Line 2104: FROM mtl_system_items_b msi, gme_material_details gmd

2100:
2101: -- nsinghi bug#5236702. Set secondary qty only if item is DUOM controlled.
2102: CURSOR get_item_duom_ctl IS
2103: SELECT NVL(tracking_quantity_ind, 'P')
2104: FROM mtl_system_items_b msi, gme_material_details gmd
2105: WHERE gmd.inventory_item_id = msi.inventory_item_id AND
2106: gmd.organization_id = msi.organization_id AND
2107: gmd.material_detail_id = p_material_detail_id;
2108:

Line 2222: l_material_detail_rec gme_material_details%ROWTYPE;

2218: x_error_msg OUT NOCOPY VARCHAR2)
2219: IS
2220: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2221: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2222: l_material_detail_rec gme_material_details%ROWTYPE;
2223: l_in_material_detail_rec gme_material_details%ROWTYPE;
2224: l_batch_header_rec gme_batch_header%ROWTYPE;
2225: l_message_count NUMBER;
2226: l_message_list VARCHAR2(2000);

Line 2223: l_in_material_detail_rec gme_material_details%ROWTYPE;

2219: IS
2220: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2221: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2222: l_material_detail_rec gme_material_details%ROWTYPE;
2223: l_in_material_detail_rec gme_material_details%ROWTYPE;
2224: l_batch_header_rec gme_batch_header%ROWTYPE;
2225: l_message_count NUMBER;
2226: l_message_list VARCHAR2(2000);
2227: l_duom_ctl VARCHAR2(30);

Line 2232: FROM mtl_system_items_b msi, gme_material_details gmd

2228:
2229: -- nsinghi bug#5236702. Set secondary qty only if item is DUOM controlled.
2230: CURSOR get_item_duom_ctl IS
2231: SELECT NVL(tracking_quantity_ind, 'P')
2232: FROM mtl_system_items_b msi, gme_material_details gmd
2233: WHERE gmd.inventory_item_id = msi.inventory_item_id AND
2234: gmd.organization_id = msi.organization_id AND
2235: gmd.material_detail_id = p_material_detail_id;
2236:

Line 3048: FROM gme_material_details

3044: CURSOR Get_Mtl_Dtl IS
3045: SELECT release_type,
3046: NVL(phantom_type,0),
3047: phantom_line_id
3048: FROM gme_material_details
3049: WHERE material_detail_id = p_material_detail_id;
3050:
3051: CURSOR Get_pplot_count IS
3052: SELECT count(*)

Line 3157: FROM gme_material_details

3153: x_return_status OUT NOCOPY VARCHAR2,
3154: x_error_msg OUT NOCOPY VARCHAR2) IS
3155: CURSOR Get_Mtl_Dtl IS
3156: SELECT NVL(dispense_ind,'N')
3157: FROM gme_material_details
3158: WHERE material_detail_id = p_material_detail_id;
3159:
3160: ITEM_NOT_VALID EXCEPTION;
3161: l_dispense_ind VARCHAR2(2);

Line 3225: FROM gme_material_details

3221: x_error_msg OUT NOCOPY VARCHAR2) IS
3222:
3223: CURSOR Get_Release_Type IS
3224: SELECT release_type
3225: FROM gme_material_details
3226: WHERE material_detail_id = p_material_detail_id;
3227:
3228: CURSOR get_Batch_Status IS
3229: SELECT batch_status

Line 4306: FROM gme_material_details m, wms_item_locations_kfv loc

4302: IS
4303: CURSOR c_subinv_loc IS
4304: SELECT subinventory, loc.concatenated_segments,
4305: m.locator_id
4306: FROM gme_material_details m, wms_item_locations_kfv loc
4307: WHERE m.subinventory = loc.subinventory_code (+)
4308: AND m.locator_id = loc.inventory_location_id (+)
4309: AND m.batch_id = p_batch_id
4310: AND m.material_Detail_id = p_material_detail_id;