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_MATERIAL_DETAIL_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 395: l_item_rec mtl_system_items_b%ROWTYPE;

391: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
392: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
393: ,x_return_status OUT NOCOPY VARCHAR2)
394: IS
395: l_item_rec mtl_system_items_b%ROWTYPE;
396: l_status NUMBER;
397: l_subinventory VARCHAR2(30);
398: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_ins';
399: l_val_proc VARCHAR2 (100);

Line 854: l_item_rec mtl_system_items_b%ROWTYPE;

850: AND organization_id = v_org_id;
851:
852: l_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
853: l_trans_id NUMBER;
854: l_item_rec mtl_system_items_b%ROWTYPE;
855:
856: open_actual_qty_error EXCEPTION;
857: open_actual_qty_unexp_error EXCEPTION;
858: process_actual_qty_error EXCEPTION;

Line 1024: FROM mtl_system_items_b

1020: /* Bug 5681997 Added mtl_transactions_enabled_flag from item master */
1021: CURSOR cur_get_item_attrib (v_org_id NUMBER, v_item_id NUMBER) IS
1022: SELECT lot_control_code, NVL(location_control_code, 1) location_control_code, restrict_locators_code,
1023: mtl_transactions_enabled_flag
1024: FROM mtl_system_items_b
1025: WHERE organization_id = v_org_id
1026: AND inventory_item_id = v_item_id;
1027:
1028: CURSOR cur_get_step_status (v_step_id NUMBER)

Line 1037: FROM mtl_system_items_b

1033: --Bug#5129153 To find out if the item is revision controlled or not Start.
1034: CURSOR cur_get_rev_code (v_org_id NUMBER,v_item_id NUMBER)
1035: IS
1036: SELECT revision_qty_control_code
1037: FROM mtl_system_items_b
1038: WHERE organization_id = v_org_id
1039: AND inventory_item_id = v_item_id;
1040: --Bug#5129153 End.
1041: l_count_trans NUMBER;

Line 1426: ,p_item_rec IN mtl_system_items_b%ROWTYPE

1422: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1423: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1424: DEFAULT NULL
1425: ,p_trans_id IN NUMBER
1426: ,p_item_rec IN mtl_system_items_b%ROWTYPE
1427: ,x_return_status OUT NOCOPY VARCHAR2)
1428: IS
1429:
1430: l_api_name CONSTANT VARCHAR2 (30) := 'PROCESS_ACTUAL_QTY';

Line 1689: ,p_item_rec IN mtl_system_items_b%ROWTYPE

1685: END process_actual_qty;
1686:
1687: PROCEDURE construct_trans_row (
1688: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1689: ,p_item_rec IN mtl_system_items_b%ROWTYPE
1690: ,p_batch_hdr_rec IN gme_batch_header%ROWTYPE
1691: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1692: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1693: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1984: ,x_item_rec OUT NOCOPY mtl_system_items_b%ROWTYPE

1980:
1981: PROCEDURE get_item_rec (
1982: p_org_id IN NUMBER
1983: ,p_item_id IN NUMBER
1984: ,x_item_rec OUT NOCOPY mtl_system_items_b%ROWTYPE
1985: ,x_return_status OUT NOCOPY VARCHAR2)
1986: IS
1987: CURSOR cur_get_item_rec (v_org_id NUMBER, v_item_id NUMBER)
1988: IS

Line 1990: FROM mtl_system_items_b

1986: IS
1987: CURSOR cur_get_item_rec (v_org_id NUMBER, v_item_id NUMBER)
1988: IS
1989: SELECT *
1990: FROM mtl_system_items_b
1991: WHERE inventory_item_id = v_item_id
1992: AND organization_id = v_org_id;
1993:
1994: error_get_item EXCEPTION;

Line 2006: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', 'mtl_system_items_b');

2002:
2003: x_return_status := fnd_api.g_ret_sts_success;
2004:
2005: IF p_item_id IS NULL THEN
2006: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', 'mtl_system_items_b');
2007: RAISE error_get_item;
2008: END IF;
2009:
2010: OPEN cur_get_item_rec (p_org_id, p_item_id);

Line 2018: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' no record in mtl_system_items_b: ');

2014: IF x_item_rec.inventory_item_id IS NULL THEN -- not found
2015: gme_common_pvt.log_message ('PM_INVALID_ITEM');
2016:
2017: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2018: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' no record in mtl_system_items_b: ');
2019: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'inventory_item_id = ' ||p_item_id );
2020: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'organization_id = ' ||p_org_id);
2021: END IF;
2022: RAISE error_get_item;

Line 2050: ,x_item_rec OUT NOCOPY mtl_system_items_b%ROWTYPE

2046:
2047: PROCEDURE validate_item_id (
2048: p_org_id IN NUMBER
2049: ,p_item_id IN NUMBER
2050: ,x_item_rec OUT NOCOPY mtl_system_items_b%ROWTYPE
2051: ,x_return_status OUT NOCOPY VARCHAR2)
2052: IS
2053: l_api_name CONSTANT VARCHAR2 (30) := 'validate_item_id';
2054: error_validate EXCEPTION;

Line 2149: ,p_item_rec IN mtl_system_items_b%ROWTYPE

2145: END validate_item_id;
2146:
2147: PROCEDURE validate_revision (
2148: p_revision IN VARCHAR2
2149: ,p_item_rec IN mtl_system_items_b%ROWTYPE
2150: ,x_return_status OUT NOCOPY VARCHAR2)
2151: IS
2152: CURSOR cur_get_revision (
2153: v_org_id NUMBER

Line 3133: ,p_item_rec IN mtl_system_items_b%ROWTYPE

3129: END validate_contr_step_qty_ind;
3130:
3131: PROCEDURE validate_subinventory (
3132: p_subinv IN VARCHAR2
3133: ,p_item_rec IN mtl_system_items_b%ROWTYPE
3134: ,x_return_status OUT NOCOPY VARCHAR2)
3135: IS
3136: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_SUBINVENTORY';
3137: sub_not_valid EXCEPTION;

Line 3183: ,p_item_rec IN mtl_system_items_b%ROWTYPE

3179:
3180: PROCEDURE validate_locator (
3181: p_subinv IN VARCHAR2
3182: ,p_locator_id IN NUMBER
3183: ,p_item_rec IN mtl_system_items_b%ROWTYPE
3184: ,p_line_type IN NUMBER
3185: ,x_return_status OUT NOCOPY VARCHAR2)
3186: IS
3187: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_LOCATOR';

Line 3887: l_item_rec mtl_system_items_b%ROWTYPE;

3883: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3884: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
3885: ,x_return_status OUT NOCOPY VARCHAR2)
3886: IS
3887: l_item_rec mtl_system_items_b%ROWTYPE;
3888: l_batch_status NUMBER;
3889: l_status NUMBER;
3890: l_step_status NUMBER;
3891: l_material_detail_rec gme_material_details%ROWTYPE;