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.INVIDIT3 dependencies on TAB

Line 8: PROCEDURE Table_Queries(

4: -- This procedure performs several queries to determine
5: -- if attributes are updateable. This only needs to be called
6: -- when working on an existing record.
7:
8: PROCEDURE Table_Queries(
9: p_org_id IN NUMBER,
10: p_item_id IN NUMBER,
11: p_master_org IN NUMBER,
12: p_primary_uom_code IN VARCHAR2,

Line 110: l_tab_exists NUMBER := 0;

106: shelf_level NUMBER := 0;
107: serial_level NUMBER := 0;
108: trackable_level NUMBER := 0;
109: attr_name VARCHAR2(50);
110: l_tab_exists NUMBER := 0;
111: onhand_tracking_qty_ind NUMBER := 0;
112: pendadj_tracking_qty_ind NUMBER := 0;
113: tracking_qty_ind_level NUMBER := 0;
114: onhand_primary_uom NUMBER := 0;

Line 164: -- If not NULL, we will query the downstream tables.

160: BEGIN
161:
162: -- 6531911 : Removed the intialization of out variables.
163: -- Values for these will be passed from calling routines
164: -- If not NULL, we will query the downstream tables.
165: -- Intialise the variable only when called from Item form.
166: -- Changes are too huge to make in certification phase.
167: IF p_calling_routine = 'INVIDITM' THEN
168: x_onhand_lot := 0;

Line 945: Modified the below SQL to use the oe_order_lines_all Table

941: END IF;
942: -- Bug 4139938 end
943:
944: /* Bug 1923215
945: Modified the below SQL to use the oe_order_lines_all Table
946: as so_lines_all and so_line_details are obsoleted in R11i
947: */
948: -- Check for open sales order line with a different value for
949: -- so_transactions_flag than in mtl_system_items

Line 1203: We need to perform the below checks on the tables

1199: -- Used to determine if inventory_asset_flag is updateable
1200: -- Use local variables for each sql statement, return 1 variable to form
1201: -- X_cost_txn will have either 0 or 1 or 2
1202: /* Bug 14334921 START
1203: We need to perform the below checks on the tables
1204: mtl_onhand_quantities_detail
1205: mtl_material_transactions_temp
1206: mtl_material_transactions
1207: while updating the Costing_enabled_flag or inventory_asset_flag.

Line 1415: INTO l_tab_exists

1411: --Bug: 2691174 Disabling vehicle items from being edited if a corresponding
1412: -- vehicle type is exists in FTE_VEHICLE_TYPES
1413: IF INV_ITEM_UTIL.Appl_Inst_FTE <> 0 AND X_fte_vechicle_exists IS NOT NULL THEN
1414: SELECT count(1)
1415: INTO l_tab_exists
1416: FROM TAB
1417: WHERE TNAME = 'FTE_VEHICLE_TYPES'
1418: AND ROWNUM = 1;
1419: IF l_tab_exists > 0 THEN

Line 1416: FROM TAB

1412: -- vehicle type is exists in FTE_VEHICLE_TYPES
1413: IF INV_ITEM_UTIL.Appl_Inst_FTE <> 0 AND X_fte_vechicle_exists IS NOT NULL THEN
1414: SELECT count(1)
1415: INTO l_tab_exists
1416: FROM TAB
1417: WHERE TNAME = 'FTE_VEHICLE_TYPES'
1418: AND ROWNUM = 1;
1419: IF l_tab_exists > 0 THEN
1420: --Bug: 2812994 Corrected the Dynamic SQL

Line 1419: IF l_tab_exists > 0 THEN

1415: INTO l_tab_exists
1416: FROM TAB
1417: WHERE TNAME = 'FTE_VEHICLE_TYPES'
1418: AND ROWNUM = 1;
1419: IF l_tab_exists > 0 THEN
1420: --Bug: 2812994 Corrected the Dynamic SQL
1421: EXECUTE IMMEDIATE
1422: 'SELECT count(1) '||
1423: 'FROM FTE_VEHICLE_TYPES '||

Line 1446: VMI_Table_Queries(

1442: and rownum = 1;
1443: END IF;
1444:
1445: IF X_vmiorconsign_enabled IS NOT NULL OR X_consign_enabled IS NOT NULL THEN
1446: VMI_Table_Queries(
1447: p_org_id
1448: , p_item_id
1449: , X_vmiorconsign_enabled
1450: , X_consign_enabled);

Line 1453: END Table_Queries;

1449: , X_vmiorconsign_enabled
1450: , X_consign_enabled);
1451: END IF;
1452:
1453: END Table_Queries;
1454:
1455: FUNCTION Get_inv_item_id Return Number is
1456: BEGIN
1457:

Line 1476: PROCEDURE VMI_Table_Queries

1472: -- Check if the item is VMI/Consign enabled
1473: -- X_vmiorconsign_enabled = 'Y' if the item is VMI/Consign enabled, 'N' otherwise
1474: -- X_consign_enabled = 'Y' if the item is Consign enabled, 'N' otherwise
1475:
1476: PROCEDURE VMI_Table_Queries
1477: ( p_org_id IN NUMBER
1478: , p_item_id IN NUMBER
1479: , X_vmiorconsign_enabled OUT NOCOPY NUMBER
1480: , X_consign_enabled OUT NOCOPY NUMBER

Line 1522: END VMI_Table_Queries;

1518: else
1519: X_consign_enabled := 0;
1520: end if;
1521:
1522: END VMI_Table_Queries;
1523:
1524: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1525: -- Added for 11.5.10 bug 3171098
1526: -- Check for proper catalog category setup for PLM

Line 1698: PROCEDURE CSI_Table_Queries (

1694: RETURN l_return_value;
1695: END CHECK_ITEM_APPROVED;
1696:
1697: --Added for Bug: 4569555
1698: PROCEDURE CSI_Table_Queries (
1699: p_inventory_item_id IN NUMBER
1700: ,p_organization_id IN NUMBER
1701: ,X_ib_ret_status OUT NOCOPY VARCHAR2
1702: ,X_ib_msg OUT NOCOPY VARCHAR2) IS

Line 1737: END CSI_Table_Queries;

1733: ELSE
1734: X_ib_ret_status:= FND_API.G_RET_STS_SUCCESS;
1735: X_ib_msg := NULL;
1736: END IF;
1737: END CSI_Table_Queries;
1738:
1739: END INVIDIT3;