APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_PARAMETERS

Line 722: FROM mtl_parameters

718: SELECT serial_number_type, -- serial number uniqueness control
719: default_cost_group_id
720: INTO l_serial_type,
721: l_cst_grp_id
722: FROM mtl_parameters
723: WHERE organization_id = p_inv_org_id;
724: EXCEPTION
725: WHEN no_data_found THEN
726: l_return_value := FALSE;

Line 955: mtl_parameters p

951: BEGIN
952: SELECT 'x'
953: INTO l_temp
954: FROM mtl_serial_numbers s,
955: mtl_parameters p
956: WHERE s.current_organization_id = p.organization_id
957: AND s.serial_number = p_serial_number
958: AND p.serial_number_type = 3
959: AND ROWNUM = 1;

Line 1294: FROM mtl_parameters

1290: l_return_value := TRUE;
1291: BEGIN
1292: SELECT serial_number_type -- serial number uniqueness control
1293: INTO l_serial_type
1294: FROM mtl_parameters
1295: WHERE organization_id = p_inv_org_id;
1296: EXCEPTION
1297: WHEN no_data_found THEN
1298: l_return_value := FALSE;

Line 1443: mtl_parameters p

1439: BEGIN
1440: SELECT 'x'
1441: INTO l_temp
1442: FROM mtl_serial_numbers s,
1443: mtl_parameters p
1444: WHERE s.current_organization_id = p.organization_id
1445: AND s.serial_number = p_serial_number
1446: AND p.serial_number_type = 3
1447: AND ROWNUM = 1;

Line 1563: FROM mtl_parameters

1559: -- Get the lot uniqueness type for the transacting organization
1560: BEGIN
1561: SELECT lot_number_uniqueness -- lot number uniqueness control
1562: INTO l_lot_type
1563: FROM mtl_parameters
1564: WHERE organization_id = p_inv_org_id;
1565: EXCEPTION
1566: WHEN NO_DATA_FOUND THEN
1567: l_return_value := FALSE;

Line 1794: FROM mtl_parameters

1790: l_drive_qty NUMBER := 0;
1791:
1792: Cursor c1 is
1793: SELECT negative_inv_receipt_code
1794: FROM mtl_parameters
1795: WHERE organization_id = p_inv_organization_id;
1796:
1797: BEGIN
1798:

Line 3587: FROM mtl_parameters

3583: l_return_value BOOLEAN := TRUE;
3584:
3585: Cursor c1 is
3586: SELECT negative_inv_receipt_code
3587: FROM mtl_parameters
3588: WHERE organization_id = p_inv_organization_id;
3589: BEGIN
3590: -- IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN
3591: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized

Line 5581: from MTL_PARAMETERS

5577: --
5578: Begin
5579: select 'x'
5580: into l_exists
5581: from MTL_PARAMETERS
5582: where organization_id = p_master_org_id
5583: and master_organization_id = p_master_org_id;
5584: l_return_value := TRUE;
5585: Exception