APPS.INV_CONSIGNED_VALIDATIONS dependencies on DUAL

Line 107: SELECT 1 INTO l_table_count FROM dual

103: --AND organization_id = p_organization_id;
104: -- Use Exists to check existance
105: l_table_count := 0;
106: BEGIN
107: SELECT 1 INTO l_table_count FROM dual
108: WHERE EXISTS (SELECT 1 FROM mtl_consigned_qty_temp
109: WHERE inventory_item_id = p_inventory_item_id
110: AND organization_id = p_organization_id);
111: EXCEPTION

Line 407: -- To improve performance, avoid using select from dual;

403: -- Therefore onhand quantity only query from MOQD
404: -- pjm support
405: --
406: /*IF g_unit_eff_enabled IS NULL THEN
407: -- To improve performance, avoid using select from dual;
408: g_unit_eff_enabled := pjm_unit_eff.enabled;
409: --SELECT pjm_unit_eff.enabled INTO g_unit_eff_enabled FROM dual;
410: END IF; */
411: --IF g_unit_eff_enabled <> 'Y' THEN

Line 409: --SELECT pjm_unit_eff.enabled INTO g_unit_eff_enabled FROM dual;

405: --
406: /*IF g_unit_eff_enabled IS NULL THEN
407: -- To improve performance, avoid using select from dual;
408: g_unit_eff_enabled := pjm_unit_eff.enabled;
409: --SELECT pjm_unit_eff.enabled INTO g_unit_eff_enabled FROM dual;
410: END IF; */
411: --IF g_unit_eff_enabled <> 'Y' THEN
412: l_onhand_qty_part := ' moq.primary_transaction_quantity ';
413: l_mmtt_qty_part := ' mmtt.primary_quantity ';

Line 1614: SELECT 1 INTO l_table_count FROM dual

1610: --AND organization_id = p_organization_id;
1611: --Use Exists to check existance
1612: l_table_count := 0;
1613: BEGIN
1614: SELECT 1 INTO l_table_count FROM dual
1615: WHERE EXISTS (SELECT 1 FROM mtl_consigned_qty_temp
1616: WHERE inventory_item_id = p_inventory_item_id
1617: AND organization_id = p_organization_id);
1618: EXCEPTION

Line 2040: SELECT 1 INTO l_pending_txn_cnt FROM dual

2036: IF p_locator_id IS NOT NULL THEN
2037:
2038: IF p_item_id IS NOT NULL AND p_lpn_id IS NULL THEN
2039:
2040: SELECT 1 INTO l_pending_txn_cnt FROM dual
2041: WHERE exists (select 1 from mtl_material_transactions_temp
2042: where organization_id = P_ORGANIZATION_ID
2043: and Nvl(transaction_status,1) in (1,3) --pending txn
2044: AND inventory_item_id = p_item_id

Line 2050: SELECT 1 INTO l_pending_txn_cnt FROM dual

2046: and LOCATOR_ID = p_locator_id);
2047:
2048: ELSIF p_lpn_id IS NOT NULL AND p_item_id IS NULL THEN
2049:
2050: SELECT 1 INTO l_pending_txn_cnt FROM dual
2051: WHERE exists (select 1 from mtl_material_transactions_temp
2052: where organization_id = P_ORGANIZATION_ID
2053: and Nvl(transaction_status,1) in (1,3) --pending txn
2054: AND ((transfer_lpn_id = p_lpn_id)

Line 2066: SELECT 1 INTO l_pending_txn_cnt FROM dual

2062: ELSE--p_locator_id IS NULL
2063:
2064: IF p_item_id IS NOT NULL AND p_lpn_id IS NULL THEN
2065:
2066: SELECT 1 INTO l_pending_txn_cnt FROM dual
2067: WHERE exists (select 1 from mtl_material_transactions_temp
2068: where organization_id = P_ORGANIZATION_ID
2069: and Nvl(transaction_status,1) in (1,3) --pending txn
2070: AND inventory_item_id = p_item_id

Line 2075: SELECT 1 INTO l_pending_txn_cnt FROM dual

2071: and SUBINVENTORY_CODE = P_SUBINVENTORY_CODE);
2072:
2073: ELSIF p_lpn_id IS NOT NULL AND p_item_id IS NULL THEN
2074:
2075: SELECT 1 INTO l_pending_txn_cnt FROM dual
2076: WHERE exists (select 1 from mtl_material_transactions_temp
2077: where organization_id = P_ORGANIZATION_ID
2078: and Nvl(transaction_status,1) in (1,3) --pending txn
2079: AND ((transfer_lpn_id = p_lpn_id)

Line 4238: SELECT 1 INTO l_table_count FROM dual

4234:
4235: --Use Exists to check existance
4236: l_table_count := 0;
4237: BEGIN
4238: SELECT 1 INTO l_table_count FROM dual
4239: WHERE EXISTS (SELECT 1 FROM mtl_consigned_qty_temp
4240: WHERE inventory_item_id = p_inventory_item_id
4241: AND organization_id = p_organization_id);
4242: EXCEPTION