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 355: l_item_rec mtl_system_items_b%ROWTYPE;

351: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
352: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
353: ,x_return_status OUT NOCOPY VARCHAR2)
354: IS
355: l_item_rec mtl_system_items_b%ROWTYPE;
356: l_status NUMBER;
357: l_subinventory VARCHAR2(30);
358: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_ins';
359: l_val_proc VARCHAR2 (100);

Line 814: l_item_rec mtl_system_items_b%ROWTYPE;

810: AND organization_id = v_org_id;
811:
812: l_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
813: l_trans_id NUMBER;
814: l_item_rec mtl_system_items_b%ROWTYPE;
815:
816: open_actual_qty_error EXCEPTION;
817: open_actual_qty_unexp_error EXCEPTION;
818: process_actual_qty_error EXCEPTION;

Line 984: FROM mtl_system_items_b

980: /* Bug 5681997 Added mtl_transactions_enabled_flag from item master */
981: CURSOR cur_get_item_attrib (v_org_id NUMBER, v_item_id NUMBER) IS
982: SELECT lot_control_code, NVL(location_control_code, 1) location_control_code, restrict_locators_code,
983: mtl_transactions_enabled_flag
984: FROM mtl_system_items_b
985: WHERE organization_id = v_org_id
986: AND inventory_item_id = v_item_id;
987:
988: CURSOR cur_get_step_status (v_step_id NUMBER)

Line 997: FROM mtl_system_items_b

993: --Bug#5129153 To find out if the item is revision controlled or not Start.
994: CURSOR cur_get_rev_code (v_org_id NUMBER,v_item_id NUMBER)
995: IS
996: SELECT revision_qty_control_code
997: FROM mtl_system_items_b
998: WHERE organization_id = v_org_id
999: AND inventory_item_id = v_item_id;
1000: --Bug#5129153 End.
1001: l_count_trans NUMBER;

Line 1386: ,p_item_rec IN mtl_system_items_b%ROWTYPE

1382: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1383: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1384: DEFAULT NULL
1385: ,p_trans_id IN NUMBER
1386: ,p_item_rec IN mtl_system_items_b%ROWTYPE
1387: ,x_return_status OUT NOCOPY VARCHAR2)
1388: IS
1389:
1390: l_api_name CONSTANT VARCHAR2 (30) := 'PROCESS_ACTUAL_QTY';

Line 1546: ,p_item_rec IN mtl_system_items_b%ROWTYPE

1542: END process_actual_qty;
1543:
1544: PROCEDURE construct_trans_row (
1545: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1546: ,p_item_rec IN mtl_system_items_b%ROWTYPE
1547: ,p_batch_hdr_rec IN gme_batch_header%ROWTYPE
1548: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1549: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1550: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1841: ,x_item_rec OUT NOCOPY mtl_system_items_b%ROWTYPE

1837:
1838: PROCEDURE get_item_rec (
1839: p_org_id IN NUMBER
1840: ,p_item_id IN NUMBER
1841: ,x_item_rec OUT NOCOPY mtl_system_items_b%ROWTYPE
1842: ,x_return_status OUT NOCOPY VARCHAR2)
1843: IS
1844: CURSOR cur_get_item_rec (v_org_id NUMBER, v_item_id NUMBER)
1845: IS

Line 1847: FROM mtl_system_items_b

1843: IS
1844: CURSOR cur_get_item_rec (v_org_id NUMBER, v_item_id NUMBER)
1845: IS
1846: SELECT *
1847: FROM mtl_system_items_b
1848: WHERE inventory_item_id = v_item_id
1849: AND organization_id = v_org_id;
1850:
1851: error_get_item EXCEPTION;

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

1859:
1860: x_return_status := fnd_api.g_ret_sts_success;
1861:
1862: IF p_item_id IS NULL THEN
1863: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', 'mtl_system_items_b');
1864: RAISE error_get_item;
1865: END IF;
1866:
1867: OPEN cur_get_item_rec (p_org_id, p_item_id);

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

1871: IF x_item_rec.inventory_item_id IS NULL THEN -- not found
1872: gme_common_pvt.log_message ('PM_INVALID_ITEM');
1873:
1874: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1875: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' no record in mtl_system_items_b: ');
1876: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'inventory_item_id = ' ||p_item_id );
1877: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'organization_id = ' ||p_org_id);
1878: END IF;
1879: RAISE error_get_item;

Line 1907: ,x_item_rec OUT NOCOPY mtl_system_items_b%ROWTYPE

1903:
1904: PROCEDURE validate_item_id (
1905: p_org_id IN NUMBER
1906: ,p_item_id IN NUMBER
1907: ,x_item_rec OUT NOCOPY mtl_system_items_b%ROWTYPE
1908: ,x_return_status OUT NOCOPY VARCHAR2)
1909: IS
1910: l_api_name CONSTANT VARCHAR2 (30) := 'validate_item_id';
1911: error_validate EXCEPTION;

Line 2005: ,p_item_rec IN mtl_system_items_b%ROWTYPE

2001: END validate_item_id;
2002:
2003: PROCEDURE validate_revision (
2004: p_revision IN VARCHAR2
2005: ,p_item_rec IN mtl_system_items_b%ROWTYPE
2006: ,x_return_status OUT NOCOPY VARCHAR2)
2007: IS
2008: CURSOR cur_get_revision (
2009: v_org_id NUMBER

Line 2989: ,p_item_rec IN mtl_system_items_b%ROWTYPE

2985: END validate_contr_step_qty_ind;
2986:
2987: PROCEDURE validate_subinventory (
2988: p_subinv IN VARCHAR2
2989: ,p_item_rec IN mtl_system_items_b%ROWTYPE
2990: ,x_return_status OUT NOCOPY VARCHAR2)
2991: IS
2992: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_SUBINVENTORY';
2993: sub_not_valid EXCEPTION;

Line 3039: ,p_item_rec IN mtl_system_items_b%ROWTYPE

3035:
3036: PROCEDURE validate_locator (
3037: p_subinv IN VARCHAR2
3038: ,p_locator_id IN NUMBER
3039: ,p_item_rec IN mtl_system_items_b%ROWTYPE
3040: ,p_line_type IN NUMBER
3041: ,x_return_status OUT NOCOPY VARCHAR2)
3042: IS
3043: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_LOCATOR';

Line 3696: l_item_rec mtl_system_items_b%ROWTYPE;

3692: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3693: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
3694: ,x_return_status OUT NOCOPY VARCHAR2)
3695: IS
3696: l_item_rec mtl_system_items_b%ROWTYPE;
3697: l_batch_status NUMBER;
3698: l_status NUMBER;
3699: l_step_status NUMBER;
3700: l_material_detail_rec gme_material_details%ROWTYPE;